web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Experimental Features / How to filter the drop...
Power Apps - Power Apps Experimental Features
Suggested answer

How to filter the dropdown using sharepoint group access

(2) ShareShare
ReportReport
Posted on by RN-29070517-0 4
Hello,
 
I have created an access SharePoint list with 2 columns BU and DG,
Each item in list I have provided access using advanced option and given different SharePoint group for each item
SharePoint group access been created based on BU.
Now I have created a dropdown with BU name,
 
Need to restrict the user based on the particular SharePoint group should see their respective BU only.
 
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 149,317 Most Valuable Professional on at
    How to filter the dropdown using sharepoint group access
    There are options than the ChatGPT-generated response below, particularly as it does not show the steps for the HTTP request required - if you really want to follow that path, then this video should get you though it.
    The much easier way is to create Office365 Security Groups, which can be shared with both SharePoint and Power Apps. You can query the member of these groups directly in Power Apps with Office365Groups.ListGroupMembers 
    User().Email in Office365Groups.ListGroupMembers(
    "YourGroupIdHere"
).value.mail
    will return true or false if the user is a member (or not)
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    Visit my blog Practical Power Apps    LinkedIn    Buy me a coffee
  • Suggested answer
    Jon Unzueta Profile Picture
    Jon Unzueta 1,215 Super User 2025 Season 2 on at
    How to filter the dropdown using sharepoint group access
     
    To restrict users in Power Apps so they only see their respective BU (Business Unit) based on their SharePoint group membership, you can follow this approach:
    ✅ Solution Overview
    You’ll need to:
    1. Map SharePoint groups to BU values.
    2. Identify the current user's group membership.
    3. Filter the dropdown based on that membership.
    🔧 Step-by-Step Implementation
    🔹 1. Create a Mapping Table
    In SharePoint or Dataverse, create a table like:
    BU Name SharePoint Group Name
    Finance FinanceGroup
    HR HRGroup
    IT ITGroup
    This helps you associate each BU with a SharePoint group.
    🔹 2. Detect User’s Group Membership
    Unfortunately, Power Apps cannot directly check SharePoint group membership. You’ll need to use Power Automate or Graph API:
    Option A: Power Automate Flow
    • Trigger: On app load or button click.
    • Action: Use HTTP request to SharePoint to check if the user is in a group.
    • Return: List of BUs the user has access to.
    Option B: Microsoft Graph API (Advanced)
    • Use Graph API to query group membership.
    • Requires Azure AD app registration and permissions.
    🔹 3. Filter the Dropdown
    Once you have the list of accessible BUs:
    Where UserGroups is a collection returned from Power Automate.
    🔐 Security Tip
    This method hides data in the UI, but does not prevent access if users know how to bypass it. For sensitive data, enforce security at the SharePoint or Dataverse level using permissions.
    Would you like help building the Power Automate flow to check group membership and return BU values? I can guide you step-by-step or provide a sample flow.


     
     
    🏷️ Tag me if you have any further questions or if the issue persists. ✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems. ❤️ Give it a Like if you found the approach useful in any way.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans