Unanswered

I would like to create a Sharepoint List that syncs with a Microsoft Groups and adds and deletes members

(1) Share

Report

Posted on by jmasz

I would like to use Power Automate to create an Employee Directory in Sharepoint that syncs with the Microsoft 365 group and deletes entries that have been removed and does not DUPLICATE entries.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

David_MA 14,815 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
I am reading your post two different ways. Which do you want to do:

When you add/remove someone from a Microsoft 365 group, you want to add/remove details about the person in a SharePoint list?

When you add/remove someone from a SharePoint list, you want to add/remove them from a Microsoft 365 group?

If the flow is triggered from the SharePoint list, what defines when a person has been added?

Was this reply helpful? Yes No
jmasz on at

Like (1)

Report
Copy link

Link copied!

Option 1: When you add/remove someone from a Microsoft 365 group, you want to add/remove details about the person in a SharePoint list?

Was this reply helpful? Yes No
David_MA 14,815 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
You can use the trigger When a group member is added or removed. Just configure the trigger to the group you want to monitor. You will need to create one flow for additions and one flow for deletions. Each will use a trigger condition to determine if it was a delete or addition.

For the flow when someone is added, use this trigger: @empty(triggerOutputs()?['body/@removed'])

For the flow when someone is deleted, use this trigger: @not(empty(triggerOutputs()?['body/@removed']))

Follow the trigger with a Get user profile (V2) action and populate the user (UPN) value with the User Id from the trigger.

Finally, add a Create SharePoint list item action to for the flow that checks for additions.

For the flow that checks for deletions, you can use the Get items action and use a filter query to filter it to the item related to the user.

Was this reply helpful? Yes No