Hi
I am trying to wrap my head around how to create a power automate flow that keeps a staff list updated to the current employees.
I have an AD group that i keep updated with all my current employees, is it possible to keep a list updated so when a person is added to this AD group a power automate flow gets triggered to add this user to the Sharepoint list and vice versa when the user is removed from the AD group a flow is triggered to remove said user from the SharePoint List?
Thank you very much, it worked like a charm once i figured out how to use Filter Query and a few other bits.
There's a Power Automate trigger called "When a Group Member is Added or Removed". You can use that, and point it at the group you're monitoring.
Next, a condition. You'll evaluate this condition: