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’)

Flow Approvals:
https://www.youtube.com/playlist?list=PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe

Dynamic approvers Power Automate:
https://www.youtube.com/watch?v=GyoD0DD_fW0

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

Flow Trigger Conditions:
https://www.youtube.com/playlist?list=PLTyFh-qDKAiGFDykUngHNNstTABnc-tLv

Table of Contents:
00:00 – Introduction
00:34 – Create a Power App from SharePoint List
02:49 – Share Power App with Users
03:23 – Does user need SharePoint Permissions for Power Apps?
06:12 – Grant access to users (Edit, Read permissions) on SharePoint (Owners, Members Groups)
07:34 – Audience Targeting Vs Security of SharePoint data in Power Apps
09:25 – Item Level Permissions List / Library setting (Read data created by user & edit data created by user)
13:07 – Owners Group has full control (No Item Level Permissions)
13:59 – Set Custom Item Level Permissions to list items via Power Automate flow
15:06 – Create flow to set row security / list item permissions
21:56 – Flow Set List Item Permissions based on Conditions
22:35 – Set Folder Security
24:31 – Create flow to Move Items and Reset Role Inheritance (Folder Security)
33:12 – Subscribe to Reza Dorrani channel

#PowerApps #SharePoint #Permissions #Security

🤝 Let’s connect on social:
🔗 LinkedIn: https://www.linkedin.com/in/rezadorrani/
🐦 Twitter: https://twitter.com/rezadorrani