Power Apps Ideas

DavesTechTips · ‎09-11-2019

Hi everyone, The new JSON function in PowerApps is great and we have been using it extensively. Another great addition would be to parse JSON directly in PowerApps. If PowerApps receives a stringified JSON string, it should be able to easily Parse this and use this data in the app, to write it into a collection, variable or whatever. We have been using the HTTP response in flow to return dynamic data to PowerApps, but seeing that this is now longer included in the Office 365 entitlement and that normal Respond To PowerApps Flow action not supporting Arrays or JSON, this request is quite urgent. Please let us know if you have any questions or suggestions. Kind regards Dawid van Heerden Follow on Twitter: @davestechtips Subscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1

cakhaing · ‎07-03-2019

Currently, customisation of PowerApps/Dynamics portal heavily relies on JavaScript. PCF is coming to canvas app too. Please bring PCF to PowerApps portal, making it one component framework to rule all model-driven app, cavas app, and PowerApps portal, in the future.

Anonymous · ‎02-22-2018

Problem: One of the biggest issues in PowerApps right now is that we cannot protect our data. If we connect any data source to PowerApps (Excel, SharePoint List, SQL Server Connection) it has to be shared with all users for them to be able to use the app. This creates a problem where user has access directly to data source and can bypass the app to do direct modifications to the data source as well as see information not meant to be seen by them. If your app was built to limit users access to some data, for example: Showing users only their vacation requests and hiding other user vacations Showing user only their travel request and hiding other user travels That means that all users can see all data as well as they can modify it without any trace. In case of Excel file on OneDrive we need to give users access to this file, that means that user can just go on OneDrive and find the excel file and edit it. In case of SharePoint List, that means that user needs to have Edit rights to that list and can just find it on the SharePoint Site and go in and edit. In case of SQL Server Connection, that means that user can open PowerApps, click create new app, open Data Sources and the shared SQL connection will be there and he can connect to it. This will allow the user to see all tables in that SQL connection with edit rights. Idea: I believe the best way to fix it, and this will allow PowerApps to become truly powerful tool to replace most of organization applications is to give the App itself write rights to the Excel sheets, SharePoint lists or SQL Connection and not the user. This way the user will have no access to the files, SharePoint List or SQL Connection and the only way to interact with data will be through the App.

BrianKnight · ‎08-14-2018

It would be fantastic to have stored procedure access to PowerApps. It's a feature presently blocking a number of customers of ours from implementing PowerApps since much of their logic is in the sprocs already. They don't want to implement Flow for this since they see it as another cog to pay for. This seems like pretty core functionality but there must be some big technical blocker from MS implementing it.

Anonymous · ‎05-03-2018

Problem The biggest problem with developing PowerApps with Azure SQL Database is that we have to share the SQL Connector with each user of the app. What that means is that each employee can bypass the app by creating their own app and adding this connector to their app (since it is shared). They get the ability to see all the tables and views in the database. Basically, everything there is in the SQL database, on top of that they also get the ability to edit the information in any way they please. This is not an issue for non-confidential information and simple apps. However, we have plans to develop more complex apps with data that should not be seen by everyone who will be using the app. PowerApps is great as we can build custom logic on who sees what. However, since each employee can create a fake app and throw in the SQL connector that was shared with them, this means that all the security and complex data validation built in the app becomes useless. Idea I think the simplest solution would be to make the SQL Connector when sharing it, the user gets “Can use” permission, it would be great if we could give an even lower permission level like “Can use only in this App”. This would make it impossible for them to create fake apps and throw in this SQL Connector to see data they are not supposed to see. OR Another option would be that when user has “Can use” permissions on SQL Connector they would only be allowed to use it where the owner put that SQL Connection, making it impossible for them to drop this connection in their Apps or Flows. Either one of those solutions would make PowerApps a lot more useful for a large number of corporations. This would definitely push PowerApps adoption for more complex systems and bring it above other similar platforms out there.

Yahya · ‎04-30-2017

It would be nice if I can add a command to a button via which i can choose a predefined field value (in a screen) and copy its content to Clipboard. In PowerApps for mobile, this becomes a must.

Jbid · ‎05-15-2017

Please consider adding a feature to get to the appended comment history from a sharpoint list comment filed with append and versioning turned on to appear in a power app card? https://powerusers.microsoft.com/t5/PowerApps-Forum/Append-comments-Field/m-p/34968#M14383

Bryndís · ‎10-17-2018

Filtering in PowerApps is not user friendly , the option to create a view in power apps (filter) based on Sharepoint List view would make life a lot easier. Creating a filter in PowerApps is very time consuming compared to a list view in sharepoint. example of usage is a sharepoint list that has a status field ( choice field ;new, in progress , completed) and assigned to field (person field), where you would want to show in the power apps... new requests assigned to the user logged in.

D365Ideas_Admin · ‎02-04-2019

According to this** blog: "By design, whenever any entity metadata is changed all duplicate rules associated with that entity are unpublished." Please, please change this design. I'm dealing with a client now that has 9MB of -open- leads because they (seem to) constantly tinker with the Lead form and weren't aware that the duplicate detection rules weren't active. **http://www.madronasg.com/blog/duplicate-detection-rules-automatically-unpublished

ashokpershad · ‎07-30-2018

I think there should be functionality to build App from the excel file stored in Sharepoint? I know its possible to make App directly from Sharepoint-List but to make same from excel file stored in Share Point will be more beneficial because excel is used more as compared to Sharepoint - List

D365Ideas_Admin · ‎02-04-2019

Our duplicate detection rules keep unpublishing themselves. I'm assuming it happens when a solution is deployed -> http://www.madronasg.com/blog/duplicate-detection-rules-automatically-unpublished So my suggestion is that system automatically re-publish the duplicate detection rules when a solution is published. Or give the admin the option to automatically republish the rules.

Silverleaf · ‎05-05-2016

For me, exporting a form, or gallery to a PDF would be even more helpful than printing and still allow me to print a final "report" from a form or gallery.

MWilliams86 · ‎10-30-2017

Add a scrollable screen control that allows the designer to either set where the scroll bar position is or reset the scrollbar to top. Currently the screen remembers its position when you navigate away from it, then if you navigate back to that screen, the screen may not be reset back to the top of the items to display which is a negative user experience forcing the user to scroll back to the top of the scrollable screen.

Anonymous · ‎08-18-2017

I have received some feedback from my app users that it is sometimes hard to tell when image or text is clickable. On the desktop version, when you hover over an image the icon remains the same or when you hover a text it changes to the edit text icon, the mouse icon seems to change to hand icon only when hovering over objects like Icons or Controls like Button control. Example 1 The text in the Org Browser by Microsoft says View My Profile, when hovering over it with mouse, the mouse icon changes to select text icon. Example 2 When using images as buttons, the mouse will stay as a cursor and will not change to the hand icon. Example 3 Hovering mouse over the button. It changes to hand icon and it is clear that you can click it. This is not a problem on the Phone since you click with your fingers but it confuses the users on desktop. Would it be possible to make all objects with functions in OnSelect property to have a <a> tag or something similar that it would force the mouse cursor to change into hand?

Underdog1987 · ‎07-25-2018

Add MaxDate and MinDate properties to avoid selecting dates out of range. Examples: Avoid selecting dates in the past: Datepicker1.MinDate: Today() Set maximum selectable date to 1 year in the future since today: Datepicker1.MaxDate: DateAdd( Today(), 1, Years ) Attached image shows what it would look like MinDate property 🙂

D365Ideas_Admin · ‎02-04-2019

When we add an entity to a CRM solution, it drags along the schema, views, forms, charts, and many other sub-components. This makes it incredibly difficult to ship a small solution change from one CRM org to another and it makes it difficult for larger CRM teams to keep their work isolated from each other without having to resort to very complex conflict resolution strategies. The CRM solution model already supports exporting (and subsequent importing) of individual subcomponents if we hack the xml and take out forms/views/fields/relationships that we don't want to ship from one environment to another. The CRM solution UI does not have an add-existing or remove button for these solution components. Please add the ability to pick and choose individual solution subcomponents in the solution model instead of forcing us to bundle entity schema and UI in the same solution file. This suggestion would make it easy for us to ship a single form, view, or even a field from one development environment to another. It would enable large CRM development teams to work better together with full isolation and minimal conflicts. It would be easier to patch a production environment.

Pieter_Veenstra · ‎08-30-2018

The coding part of PowerApps can contain complex code. It would be great if the code could be simplified by storying the code in libraries that can be maintained from within the PowerApps Studio.

vecerpa · ‎05-28-2018

My idea come with error message that is being thrown when trying to get manager of user via Office365 Users connector. More details here - https://powerusers.microsoft.com/t5/General-Discussion/Office-365-Users-ManagerV2-Error/m-p/119173. As this is expected error that will be delivered by this connector it will be nice to have some option inside PowerApps to catch it and instead of displaying this for user of PA as "nothing to say" message, to diplay something like no manager found and this can lead to some other actions ... P.

BrianR · ‎08-16-2018

Please provide the ability for the code editor to pop out into a SEPARATE, moveable and resizeable window.

Username111 · ‎05-11-2018

PowerApps Team, It would be extremely beneficial if you could insert an NFC Scanner as a media (similar use of Barcode scanner). NFC tags are now being used for huge IoT projects that's why scanning NFC tags' UID and/or memory would be very useful! Thank you, Alicia

Share your ideas and vote for future features

Parse JSON in PowerApps

Bring PowerApps Component Framekwork (PCF) to PowerApps Portal

Removing user ability to access data source without using the app

Calling a Stored Procedure in PowerApps

Making SQL Connector Secure

Copy to Clipboard

Append comments Field

View in PowerApps based on sharepoint list view

Automatically republish duplication detection rules whenever an entity is published

Create App from Excel file stored on SharePoint

Automatically republish duplication detection rules whenever an entity is published

Export Form to PDF

Screen Reset/Set Scrollbar Back to Top

Changing mouse to hand icon when hovering over objects with OnSelect function

Restrict available dates in Datepicker controls

Allow discrete selection of entity-related solution components in solution export

An option to create new custom functions in PowerApps in libraries

Error handling inside PowerApps (Try-Catch)

Code Editor: Allow popout into separate resizable window / dialog

NFC tag Scanning

Helpful resources

Notify - add autodisappear and time function

Show CDS entity dependencies

Configure and publish Bots with Portals

Need a way to automatically invoke AI Builder Form...

Add a RESET Property to Text Recognition AI Builde...