How to check whether certain user id is group or not?

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I'm creating a flow to generate a all employee detail sharepoint list from azure ad when triggered.

My problem is that my company 's group mail is like

all employees group

divA group divB group divAdmin group

emp_divA emp_divB salesgroup admin group

emp_divAdmin

both office365group "list group members" and azure ad"get group members" work

but when i list group members(all employess), it just return groups

Then list group members(divgroups), it return employee mail of divA and divB,but

for divAdmin it just return salesgroup and admin group.

Is there a way to determine whether the mail is a group mail and get group member mail until it is a employee mail?

my current flow is like this.

無題.png

thanks for you help

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

v-yamao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

I assume that there might be a specific character “Group” in the email address, then you could consider using a Do-until loop to get the flow keep running until it isn’t a group email.

Please take this blog on do-until for more details:

https://syscloudpro.com/2018/05/20/microsoft-flow-mystery-of-do-until-loop/

Best regards,

Mabel Mao

Was this reply helpful? Yes No
GabrielStJohn Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello, @Anonymous!

Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@v-yamao-msft @GabrielStJohn
Sorry for late reply, I had a-week off.
The problem is that what I want to get is not a specific person.
I want to get all users from a group mail which is consist of several group mails.

The level is like this:
all users
   a group of people I want to get
   div A divB    divC
   emp_divA emp_divB divC-A divC-B
emp_divC-A emp_divC-B

I want to get all of the user mails in divA,divB,divC

First I use list group members (a group of people I want to get)

It returns three group mails:divA,divB,divC
then I use list group members (for each value)
It returns employee's mail emp_divA emp_divB and two group mails divC-A divC-B
If i continue, the flow will fail for emp_divA is not a group mail and has no group members

That is why I want to know whether there is a way to decide a mail is a group mail or not

Thanks for your help.

Was this reply helpful? Yes No