MENU

Fun & Interesting

Power Apps SharePoint List Security | Item Level Permissions & Folder Security with Power Automate

Reza Dorrani 119,053 3 years ago
Video Not Working? Fix It Now

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

Comment