Share your ideas and vote for future features

Hi,   Looking for visitor printing feature in canvas app. ... View more

Hi PowerApps team,   Please set always a default to each column of a collection! Oke, let me try to explain. I will first scetch the situation, then give the issue I'm experiencing and a last the current workaround needed. Situation Let's say we have a collection for employees with multiple columns: [ID, FirstName, LastName, DisplayName, RoleID, RoleName] I bring in the items with Flow(), so on app start I have items in my collection. Now I want to be able to update and create items in my collection.    For Update I use a Variable Record (I set this by selecting the record in a gallery with UpdateContext({MySelectedItem:ThisItem}) This variable I use for my form. Till so far no problems.    Now I make changes and want to save them in my Collection and my DataSource. For that I use an other collection _EmployeePost. What I want to do is Set(_EmployeePostID,MySelectedItem.ID) ;Collect(_EmployeePost, MySelectedItem) ;Patch(_EmployeePost, LookUp(_EmployeePost, ID = _EmployeePostID) ,{FirstName: "New FirstName"} ,{LastName: "New LastName"} ,{DisplayName: "New DisplayName"} ,{Role: "New Role"} ) For a new record I would like to do Set(_EmployeePostID,Max(_Employee, ID) + 1) ;Collect(_EmployeePost, {ID:_EmployeePostID}) ;Patch(_EmployeePost, LookUp(_EmployeePost, ID = _EmployeePostID) ,{FirstName: "New FirstName"} ,{LastName: "New LastName"} ,{DisplayName: "New DisplayName"} ,{Role: "New Role"} ) Issue The issue is that this won't work. This is because with an update if one field is blank()/Null this field is not set and I can't update the value here. On a new record you can't update all the fields besides the ID.   Workaround What I have to do now is: // Update Set(_EmployeePostID,MySelectedItem.ID) ;Collect(_EmployeePost , {ID: If(IsBlank(MySelectedItem.ID),"", MySelectedItem.ID)} ,{FirstName: If(IsBlank(MySelectedItem.FirstName),"", MySelectedItem.FirstName)} ,{LastName: If(IsBlank(MySelectedItem.LastName),"", MySelectedItem.LastName)} ,{DisplayName: If(IsBlank(MySelectedItem.DisplayName),"", MySelectedItem.DisplayName)} ,{Role: If(IsBlank(MySelectedItem.Role),"", MySelectedItem.Role)} ) ;Patch(_EmployeePost, LookUp(_EmployeePost, ID = _EmployeePostID) ,{FirstName: "New FirstName"} ,{LastName: "New LastName"} ,{DisplayName: "New DisplayName"} ,{Role: "New Role"} ) // Insert Set(_EmployeePostID,Max(_Employee, ID) + 1) ;Collect(_EmployeePost , {ID:_EmployeePostID} ,{FirstName: ""} ,{LastName: ""} ,{DisplayName: ""} ,{Role: ""} ) ;Patch(_EmployeePost, LookUp(_EmployeePost, ID = _EmployeePostID) ,{FirstName: "New FirstName"} ,{LastName: "New LastName"} ,{DisplayName: "New DisplayName"} ,{Role: "New Role"} ) You see the quantity of script and we only have a simple collection here. I hope you can imagine the time it takes to build this with a langer collection.   Hope you can fix this.   Paul ... View more

If you truly want to make PowerApps usable, you have got to provide users with a way of creating user defined variables. Too much time is spent coming up with hacks to implement reusable chunks of code (sorry, components just doesn't cut it and are clunky to use anyway). I've had easier times creating procedures in COBOL than in PowerApps. Come on people, it's time to stop this foolishness and provide us with some real programming capabilities... ... View more

the Barcode scanner control should be supported within  Microsoft Surface Book.   My surface book is designed to disconnect from the keyboard to become a tablet so this functionality should be compatible, as with other tablets. ... View more

Dear All I would like to thank the developer team of powerapps on their efforts. And I Suggest to give the option of choosing the powerapps release version to us ( platform developers). In few times my application was stopped due to new release issues for several days, until it get fixed . Hence , My suggestion will help everyone to have smooth working environments.   Best Regards KKhafaji ... View more

  Scenario:  In a Service Order app, it is desired to visualize the emails and assign them to specific users.  Simple email moving and replies would be implemented, but it is not desired to replicate a full-fledged email app inside PowerApps.  If more than a basic reply or the Service Order managemen actions are necessary, the user would like to click on a link to break out of the Service Order app into a OWA tab with the folder and message already selected.    Currently it is impossible to build the URL to OWA with the information provided by the existing functions.    --   Office365.GetEmailsV2 and Office365.GetEmail do not fetch the Folder ID or a fully qualified URL to open the message in OWA.    This causes the user to be unable to create a fully qualified link to Launch() another window to OWA with the folder and message already selected.    OWA currently does not accept plain FolderPaths in the URL (human-readable folder names), it only accepts FolderIDs.   OWA accepting FolderPaths in the URL would also be desired to make it easier to build OWA URLs, but it's beyond the scope of PowerApps Ideas I believe.  ... View more

A function to check connectivity to a gateway is sorely needed in PowerApps.  At the moment it is impossible to implement proper error handling when trying to connect to an on premesis data source.  Connection.Connected merely checks internet connectivity, and Errors([Datasource]) only includes errors returned by the datasource itself, and so is empty when the data source is not reached.   Either a function to test the gateway connection, or an inclusion of "data source unreachable" in the errors table is desperately needed. Even a function to test if any error notifications were generated by the app would do. ... View more

Hi, If there is a way to have group view for the option set which are meant for a particular power app or a purpose. Primarily to organize the option set or to quickly find the option sets belonging to particular purpose.   Example, option set belonging to medical terms or metallurgy, shall be grouped togther or tagged.    regards, Singaravelu S       ... View more

I am creating an application using the template of [Install and configure Expense Report sample for canvas app in PowerApps]. There are many inconsistencies with your own SPO list columns, so there are many places to fix manually. Therefore, I want the ability to work in tandem with SPO and convert it in bulk. ... View more

Why i can't create bussiness rule programaticaly(c#)? AI_generated_solution ... View more