Hello everyone,
In this video we will explore the security & permissions needed to work with SharePoint as a data source for your Power Apps.
We will set item level permissions using a simple setting in SharePoint lists, we will create custom item level security using Power Automate flows, break permissions, grant permissions, reset role inheritance and more.
This is true security of data in SharePoint which PowerApps will respect.
This video includes both Power Apps & Power Automate to setup and lock down access to your SharePoint data.
✅ How SharePoint Permissions with Power Apps works?
✅ Working with 🔒 item level permissions in Power Apps.
✅ Set custom Item level permissions via Power Automate flows based on conditions.
✅ Flow to move item to specific folders dynamically & inherit folder security.
🔗 Blog Link - Power Automate – How to move SharePoint Online list items to folders https://michelcarlo.com/2019/03/04/microsoft-flow-how-to-move-sharepoint-online-list-items-to-folders
⬇️ Download flows to set permissions, break permissions & more:
https://github.com/rdorrani/Microsoft-Flow/tree/master/SharePointPermissions
Code for Trigger Condition:
@equals(triggerOutputs()?['body/Progress/Value'],'Completed')
SharePoint item level / folder level permission limits:
https://support.microsoft.com/en-us/office/customize-permissions-for-a-sharepoint-list-or-library-02d770f3-59eb-4910-a608-5f84cc297782
https://docs.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits#unique-security-scopes-per-list-or-library
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
