Having trouble importing and updating users from a 365 group to a list

[Bross_TJ]

Hi Everyone. 

So I've tried youtube, google, and various posts on this forum, and I'm struggling to get this right. I am a complete novice to automate but I'm trying my best.

Im trying to build a small company-wide "Intranet" using SharePoint.  I have all my users in a group called "Intranet users," I've created a flow using the "When a member is added or removed from a group" option. Currently, the flow is working and works like this: "When a group member is added or removed" > "Get user profile (V2)" > "Create a SharePoint item," which then populates to my list.

These are the issues im having:

1. When I remove a person from the group, it adds a new entry into my list causing a duplicate instead of removing them from the list.

2. I am unable to find a way to have the list update itself when things like location, display name, location etc changes on the users themselves. 

What i want to find out is, is there a way i can build this flow to add AND remove users from the list when they are added and removed from the 365 group, and is there a way the list will be able to update entries when they are updated in 365 such as department, location, office etc...

i hope im making sense. 

Thanks in advance 🙂

[creativeopinion]

 There isn't a lot of dynamic content availalbe to select from for the flow trigger. However, you can work with what you have. Use a Compose action to output the dynamic content available and run a test. For my test, I removed a user, you can see the @removed tag outputs a value.

When you run another test and add a member, you'll see that the @removed tag will output nothing. You can add another Compose action for testing purposes.

Use an expression: equals(triggerOutputs()?['body/@removed'],null)

Run a test. You'll see that if a user is added, it will return true, if a user is removed, it'll return false.

 Updating Media

With that knowledge, you can add a Trigger Condition. This way your flow will only trigger when a user is added.

For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this tutorial I cover:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

@Bross_TJ

[Bross_TJ]

Awesome thank you so much! I will test this shortly and revert!

[Bross_TJ]

I thought i got it to work but it looks like its not working. Im still trying to figure it out. Will revert

@creativeopinion 

[creativeopinion]

@Bross_TJ which part of your flow isn't working?