Control access with RecordInfo and DataSourceInfo in Power Apps
When you create apps, you might find that different users get different things to do. With RecordInfo and DataSourceInfo you can control elements in your app by using Dataverse permissions
DataSourceInfo
When you use a table in Dataverse that a user doesn’t have access to you might get these error messsages:
You don’t have access to view this data. Server Response <Tablename> failed.
The message is clear, the user hasn’t been given access to a table that the app needs to read.
Now you could create a user role with some permissions on the table and the error message will go away. But what if, the user shouldn’t have access to this table and you want the app to behave differently for different types of users.
You could end up with many apps different apps, or you could handle this using the DatasourceInfo function.
In my case I’ve got a gallery that displays my fruit from my table. Using the following line, I can check if the user has read access to the table.
If(DataSourceInfo(Fruits,DataSourceInfo.ReadPermission), Fruits)
Now when the user doesn't have access to the table no error will be thrown.RecordInfo
Whereas DatasourceInfo works on the full table, sometimes you might want to use similar tricks on a record by record basis.
Potentially, you could accomplish the delete button using somethign like:
If(DataSourceInfo(Fruits,DataSourceInfo.DeletePermission), Fruits)However, you might sometimes have different permissions configured at a record level.
This is where the RecordInfo Function comes in and something like this on the Visibility property would then work.
RecordInfo(ThisItem, RecordInfo.DeletePermission)Quite often you will find that delete permissions are set at a table level but it is not uncommon to have edit permissions set at a record level. That way you could change the Edit button into a View button like this:
If(RecordInfo(ThisItem, RecordInfo.EditPermission),”Edit”, “View”)
General thoughts
I’ve seen quite a few apps that have their own role based security baked into the app, but if you can use RecordInfo and DatasourceInfo instead then you can take all that security complexity work away from your app and place it where it belongs, in your data model.
One limitation, however, the two functions described in this post, only work with Dataverse. Hopefully this will support SharePoint lists as well one day.
You could also use this to check if a developer or another user is logged in, by checking access on the solutions table. Then you could hide all those little debug options that you may add as a developer.
Continue Reading Pieter Veenstra’s Article on their blog
Control access with RecordInfo and DataSourceInfo in Power Apps
When you create apps, you might find that different users get different things to do. With RecordInfo and DataSourceInfo you can control elements in your app by using Dataverse permissions When you use a table in Dataverse that a user doesn’t have access to you might get these error messsages: You don’t have access to view this data.
Blog Syndicated with Pieter Veenstra’s Permission
More About This Author
Array
Modern Workplace26 March 2024Receive the available storage within your SharePoint Online tenant- Modern Workplace20 March 2024Options for Documenting Your Power Apps: Comments, Code, and Controls
- Modern Workplace18 March 20242 ways to duplicate SharePoint Lists to support your Power Apps
- Modern Workplace14 March 2024Update a Hyperlink Column in SharePoint with Power Automate
