Power Apps connection with SharePoint

Like (2) Share

Report

Posted on 17 Apr 2025 11:03:58 by CU04120934-0

I have a SharePoint list with staff and manager columns , but in some cases some staffs have more than one Manager , these managers have been put in a Microsoft 365 Group instead of listing the Managers individually

Now in Power apps , I want the logged in User to only see records of Staffs they manage

How do I use Power Apps to check if the logged in user belongs to any of the groups listed in the Manager column in SharePoint

Categories:

General Questions

Connecting to Data

All responses (3)

Answers (0)

ronaldwalcott 3,653 on 17 Apr 2025 at 23:18:47

Like (0)

Report

Power Apps connection with SharePoint

See Power Apps Get Office 365 Group Members on how to retrieve the group members.
Suggested answer

Robu1 1,218 Super User 2025 Season 1 on 17 Apr 2025 at 12:26:58

Like (0)

Report

Power Apps connection with SharePoint

Hi CU04120934-0,

Thank you for choosing Microsoft Power Platform Community.

In Power Apps, you can check if the logged-in user belongs to any of the Microsoft 365 Groups listed in the Manager column using the Microsoft Graph API along with Power Automate.

Here’s a step-by-step way to approach this:

To allow logged-in users to see only records of the staff they manage in Power Apps, follow these steps:

Retrieve User's Groups: Use the Microsoft Graph API or Office365Groups.ListUserGroups() to get the groups the logged-in user belongs to.

Compare Groups with the Manager Column: Use Power Apps functions like Filter() or LookUp() to check if any of the user’s groups match the SharePoint Manager column.

Use Power Automate if Needed: If complex filtering is required, create a Power Automate flow to retrieve the relevant records.

Power Apps Example Code
// Get groups the logged-in user belongs to
ClearCollect(UserGroups, Office365Groups.ListUserGroups().value);

// Filter staff records where Manager matches any user group
ClearCollect(FilteredRecords, Filter(StaffList, Manager in UserGroups));

This code collects the user’s groups and filters the list to display only staff members they manage.

Documentation References:

Microsoft Graph API-Microsoft Graph REST API v1.0 endpoint reference - Microsoft Graph v1.0 | Microsoft Learn

If this fixes the issue, please mark as resolved to help others with find it.

Happy to help

Robu1

SuperUser|Moderator
stampcoin 1,300 on 17 Apr 2025 at 12:23:42

Like (0)

Report

Power Apps connection with SharePoint

CU04120934-0 Hi,

You may want to try powerautomate :

from app, you get the current user email then pass to powerautomate, then List the owned groups, and then list group members.

collect the members and response back to app.

if the current user own more than 1 group, you have to use loop, for example one manager could manager mutltiple teams.