Power Apps – SharePoint Row Level Security (Using parseJSON)
One of the biggest negatives for using SharePoint in Power Apps is the lack of row level security.
One of the biggest negatives for using SharePoint in Power Apps is the lack of row level security. What do I mean? Well, SharePoint only has 3 levels of security:
- Full Read & Write
- Full Read Only
- Read & Write rows you have created
Which sounds enough, but what happens when you want multiple people to access certain rows (like a certain team or job role)? Well then you need Dataverse, which is great, but is a premium connector and isn't cheap (even not compared to free SharePoint).
Read the full blog:
https://dev.to/wyattdave/power-apps-sharepoint-row-level-security-using-parsejson-2b5o
More about this Topic
Steps to deny Power Apps users access to SharePoint data from the SharePoint UI
In a post I wrote a while ago, I explained how to create a SharePoint custom permission level and special SharePoint groups to be used in Power Apps using PnP PowerShell. And also how to break the permissions on the specified site lists while granting access to the new groups only to those lists.