I have an AAD group which stores all my Office 365 users. I am trying to use flow to check if a user is a member of a certain group. I have the users GUID and the groups GUID.
My first attempt involved using 'Get Group Members' Action, but I quickly back-tracked on this given my group is well over the top 999 limit of items which will be returned.
I have now tried to use 'Get Groups of a User'. I run a switch statement to check for 2 group GUIDS and set a variable to true if the user is a member of either group. The variable is initailised as false. The problem I am having is I keep getting false positives because 1 of the group GUIDs I am looking for, in AAD, is nested inside a group which contains all the users in my organization.
I have asked my administrators to remove the nested group, but they are reluctant.. Fearing 'unforseen circumstances'.
I have tried nesting the group I am looking for in a group which has no direct members and checking for that groups GUID, but again a false positive is returned.
I am hoping somone can help me figure out how to check if the user is a direct member of the groups I am searching for and not inheriting it from the group which holds all users.
I know this is hard to explain and I might not have done a very good job, here is my group setup
I would much appreciate and assistance.
Thanks in advance,
Hi @AlisterT ,
Have you tried to use Add user to group action?
If the specified user is already a member of the specified group, the action should fail. You only need to use configure run after to determine if the action failed.
I have tried this and unfortunately, it didn't work for me. I'm sure it would work for most people though. The reason it didn't work for me is because group 2 in my original post is Primary in on-premise AD and sync'd to AAD so the 'Add user to a group' action fails with a bad request error. I realize I failed to mention this fact in my original post. Sorry about that!
If you're interested, the bad request error detail is:
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!