Post

Role-based dropdown filtering in Power Apps

Diesen Beitrag auf Deutsch lesen

Hide a restricted SharePoint choice for unauthorised users or block them from continuing after they select it in a canvas app.

Original article from July 6, 2026: Show the Right Choices to the Right People: Role-Based Dropdown Filtering in Power Apps, by Anouck, on 365-ANOUCK. Read the original

Source may be outdated. The original article is more than 60 days old. Dates and availability refer to the state of the source.

This is our own summary, not a republication or full translation.

TL;DR

A Power Apps canvas app can check Lower(User().Email) against an allowed-user list, then either filter a restricted value from Choices() or block navigation with Notify or a disabled Next button. These controls are client-side only; data-layer enforcement needs a flow or tighter SharePoint permissions.

Why it matters

  • Makers: Use the dropdown Items formula to remove a restricted SharePoint choice for unauthorised users, or validate the selection on the Next button when the choice must remain visible.
  • Makers: Keep the allowed-user list in a small SharePoint list or Microsoft 365 group when permissions need updating without republishing the app.
  • Admins/IT: Do not treat canvas-app checks as enforcement; use item-creation automation or list permissions if unauthorised values must be prevented at the data source.

Frequently asked questions

How can a Power Apps canvas app hide a restricted SharePoint choice from unauthorised users?

Check Lower(User().Email) against an allowed-user list, then filter the restricted value out of the dropdown's Choices() formula.

What should an app do if a restricted choice must stay visible to everyone?

Block navigation instead, for example with Notify or a disabled Next button, after validating the selected choice.

Is a canvas-app check enough to truly enforce role-based access to a choice?

No. These checks are client-side only; real enforcement needs a flow or tighter SharePoint permissions at the data source.

Summary by KMUpower, licensed under CC BY 4.0 . Rights to the original article remain with its author.