cancel
Showing results for 
Search instead for 
Did you mean: 

Access control of underlying data in powerapps

Access control of underlying data in powerapps is very important. I can not give edit rights to entire excel sheet from one drive. Somehow I want to give users access to powerapps UI but not entire sql db or excel sheet just like asp.net app or sharepoint(for example runwithelevated)

 

Anonymous shared this idea  ·                        

Status: Need Info

PowerApps respects the access of the underlying datasource (otherwise it could create a security conflict). The Excel scenario is all or nothing at this time, however, in your app you could create filters (to limit the data to what they need to see) based on the user viewing the gallery. See these two videos here:

 

https://www.youtube.com/watch?v=QiJjYAsXYLY&list=PLnFZgEkUYL03vyWro12HGW6xRtNToIQIc&index=9

 

https://www.youtube.com/watch?v=QO3yFwNl_jI&index=14&list=PLnFZgEkUYL03vyWro12HGW6xRtNToIQIc

 

Thank you,

Audrie

Comments
Power Automate
Status changed to: Need Info

PowerApps respects the access of the underlying datasource (otherwise it could create a security conflict). The Excel scenario is all or nothing at this time, however, in your app you could create filters (to limit the data to what they need to see) based on the user viewing the gallery. See these two videos here:

 

https://www.youtube.com/watch?v=QiJjYAsXYLY&list=PLnFZgEkUYL03vyWro12HGW6xRtNToIQIc&index=9

 

https://www.youtube.com/watch?v=QO3yFwNl_jI&index=14&list=PLnFZgEkUYL03vyWro12HGW6xRtNToIQIc

 

Thank you,

Audrie