Automating Updates to Employee Data in Excel Based on Microsoft Group Membership

Hello,

I have an Excel file stored in SharePoint that contains all employee information for my organization, including names, email addresses, phone numbers, and job titles. I am trying to set up a Power Automate flow to manage this data based on Microsoft group membership.

Here is what I want to achieve:

If an employee is removed from a specified Microsoft group, their information should automatically be deleted from the Excel file.
If a new employee is added to the Microsoft group, their information should automatically be added to the Excel file.

I have set up a flow that:

Triggers when a group member is added or removed.
Retrieves group members and lists rows from the Excel table.
Uses a condition to compare group members with rows in the Excel file.

However, I am encountering issues with the condition and the overall structure of the flow. Specifically, I receive errors like “InvalidTemplate” or issues where the condition or array filter does not work as expected.

Could someone guide me on how to properly structure this flow? I am not using Microsoft Graph connectors—just the standard "List group members," "List rows present in a table," and Excel actions available in Power Automate.

Any help would be greatly appreciated!

Thank you!

Quick Links

Leaderboard