Hi, I am having issues with an if, then , else statement. Basically, I want to check a variable and set then set another variable but go no further if the check is true. For some reason, though, it is going and completing the code to the end (after the ;) I am thinking I am just structuring the statement incorrectly and have a close bracket in the wrong place, but I have tried so many different variations that I am now stuck. Code below and thanks in advance for any advice If(varAC="CGL", Set(gblShowModalProdMove,true), If(varAC="WS Wrapper",Set(gblShowModalProdMove,true), Patch( 'FLT Requests', Defaults('FLT Requests'), { JobType: "Finished Product Move", Location:"WS", TruckType:"Combi", ActivityCentre: varAC, Priority:2, Allocated: false, Completed: false } )); Navigate(scrSuccess, ScreenTransition.Fade))

Good morning all you wonderful Power People!. I have created an FLT app for my company where jobs can be picked up/allocated to the various types of FLT used within the business. I am now expanding on this so that Supervisors can send messages to the drivers - a very basic IM system. At the moment the system creates a specific job type (Supervisor Request) which appears in the FLT Job List. My question is this. Can i use the Patch function to add data into the Comments field (which can be set to add comments to an existing record) or will this just overwrite any existing comments that are on the record? If it does, is there a better method of adding comments so that the chain of Comments can be seen? As always, many thanks for all help and suggestions offered

Hi all. I ma wondering if anyone has come across a vehicle loading app for a fleet of HGV's and trailers? I am looking for something where trailers can be dragged and dropped into a calendar and capacities are also calculated. I have a few ideas but would like to see if something already exists somewhere out there Many thanks

Hi all I am having some difficulty using nested dropdowns in PowerApps. I have a sharepoint list which lists all GL Codes for Purchase Orders. In this list are Department, Category and Description - plus the actual GL Code. In Power Apps I have 3 dropdowns, one for the Department, one for the Category and then a final one that displays the GL Code. I want to use the last one to show the GL Code but also the Description, but it doesnt seem to work. It either shows blank or shows the same as the Category field. Here is my code for the dropdown Items property. Department - Distinct('Purchase GL Codes (Master)',Departments) Category - Distinct(Filter('Purchase GL Codes (Master)', Departments = DrpDepartment.Selected.Value),CatList) GL Code - Filter('Purchase GL Codes (Master)', GLCode, Departments=DrpDepartment.SelectedText.Value, CatList=DrpCategory.SelectedText.Value ) I would like to use a combo box for the GL Code field (so it shows the Description as well) but I am struggling to find a way to make it work. Also, I am getting delegation warnings, but I am not sure what I can do to try and rectify this As always, any help or advice would be greatly appreciated EDIT - I have finally managed to get the third drop down to work with the following code: Sort( Distinct( Filter( 'Purchase GL Codes (Master)', Departments = DrpDepartment.Selected.Value && CatList=DrpCategory.SelectedText.Value ), 'GL Code' ), Value ) I still have the delegation warnings though and I would also like to display the GL Code Description field in this dropdown box but only patch the actual GL Code. I am having some trouble formatting the query so that I can use the AddColumn command though

Let's discuss a new project we could build together: ➡️ Item (Equipment / Item / Device / Tool / etc.) Inventory Management Application 🎯 A new potential new client or a manager inside your organization comes to you with this project concept: ================================================================= "We would like to automate device management within our company. The goal is to develop a Power Apps application that handles the entire lifecycle of our devices, including: - New devices: Logging and assigning them to employees. - Returning devices: When devices are no longer needed. - Defective devices: Tracking and returning for repair or disposal. - Integrate Power Automate to send automatic notifications and generate reports. An app that combines all these processes would greatly simplify our workflow." ================================================================= What are the next few steps of action *should you* execute? - What questions should you ask? - What other people should you involve? - When should you schedule a meeting to discuss the project further?