Build a User Access Page in Power Apps

Chris Freeman

Chris Freeman

3,581 views

🔗 Automate SharePoint List Permissions with Power Automate:
Automate SharePoint List Permissions with ...

🔗 Stop Sharing Power Apps Manually:
Stop Sharing Power Apps Manually

🔗 Stop Guessing Promotion Decisions - Build a Data-Driven App:
Stop Guessing Promotion Decisions — Build ...

🚀 Permissions & Security Playlist:
Permissions and Security

🚀 Build Role-Based Security in Power Apps (User Access Levels)

Want different users to see different data inside the same Power App?

In this video, I'll show you how to build a role-based security model in Power Apps using SharePoint, Office 365 Users, Power Apps variables, and Power Automate. We'll dynamically assign access levels, control what users can see, and filter data based on their role—all from a centralized user access list.

This solution is perfect for:
• HR applications
• approval systems
• manager dashboards
• operational apps
• secure business applications
• role-based Power Apps

In this video you'll learn:
✔ How to create a user access list in SharePoint
✔ How to retrieve user information from Office 365 Users
✔ How to store security levels in Power Apps variables
✔ How to show and hide controls based on user permissions
✔ How to build dynamic gallery filtering using Switch()
✔ How to create manager-level and submitter-level visibility
✔ How to automate Power App and SharePoint permissions

We'll also cover:
• Full Access users
• Manager Access users
• Submitter Access users
• dynamic navigation controls
• security-driven UI experiences
• centralized permission management
• Power Platform security best practices

By the end of this video, you'll know how to build a scalable role-based access system that controls both the user experience and the data users can access inside your Power Apps.

#PowerApps #PowerAutomate #SharePoint #Microsoft365 #PowerPlatform #AppSecurity #BusinessAutomation


00:00 - Intro
00:52 - What we'll cover today
01:22 - Explore the SharePoint List
02:48 - Start in Power Apps
03:01 - Add in your Data
03:57 - Add the User Access Page
06:35 - Add the Gallery and Form
10:07 - Office365Users Database
11:34 - Search person in M365
17:27 - Update the Submit and Delete Buttons
20:08 - Power Apps pull in User Access Level
21:26 - Navigate with User Access
23:13 - Filter by User Access
25:38 - Power Automate User Access
30:51 - Test the Flow
32:54 - Final Thoughts