Has anyone tried below scenario?
1. I have set of users in sharepoint group
2. On load of powerapp, I will check if current user belongs to Sharepoint group
3. If he is part of the group, then load all the items in the screen
I am unable to achieve this for some reason. Can anyone please share your inputs.
There isn't any functionality that I am aware of that will get members of a SharePoint group. You could create a list in your site that contains all the users that should have access to all the fields and then OnStart or OnVisible of PowerApps you could pull that information in and use it to determine if the user can see all the fields or just some of them.
this could be a workaround. i can't confirm it as I can't check for other users.
First, add any one of the exisitng lists in your sharepoint group as a datasource. If you don't have a list just creat a dummy list so that you can connect to sharepoint. Note: the list should have the same permission as the sharepoint group
then, to test this out insert a label in the app and set its text property to
If(IsEmpty( Errors('SharepointListname')),"true","false" )
So , if the user has permissions, no errors will be returned, whereas if the user isn't a part of the sharepoint group some permission error will be returned and thus the Errors table won't be empty.
Check and let me know if it works. You will probably have to ask someone outside the group to open the app and check it.
the earlier one might not work, so try this -
If(DataSourceInfo( 'SharepointListName', DataSourceInfo.ReadPermission),"has access","doesn't have access")
If(DataSourceInfo( 'SharepointListName', DataSourceInfo.EditPermission),"has access","doesn't have access")
Check this for DataSourceInfo documentation https://docs.microsoft.com/en-us/powerapps/functions/function-datasourceinfo
This is clever...
The only downside is the underlying sharepoint list holding the data doesn't know anything about the PowerApps trick, so that data in those columns you hide in PowerApps could be viewed in the underlying list if the user has access to the list
It may be better to store the data you want to hide in another list and set the form to read data from the list holding that secure data...
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!