Org Chart Nested Loop

(0) Share

Report

Posted on by CameronTCD

108

Hey all,

Been stuck at this problem for a while now and it's driving me crazy.

I'm using "Get Direct Reports" (office 365 connector) and I'd like to one individuals name in and get all of their direct reports' indefinietely until there are none left and append them all to a list.

The theory is simple but I'm having trouble implementing it. Any help would be appreciated

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

HenWang Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CameronTCD ,

I am afraid there is no other way to avoid this issue. To conclude, adding enough number of nested loop to check whether the guy has direct reports or not is the final way.

First part:
check the first guy whether he has direct report.

The following loop:

Inside the condition, there are same configuration to check whether the specific user has direct reports.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Verified answer

CameronTCD 108 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @HenWang thanks for taking the time to reply.
After a lot of trial and error I managed to configure it in such a way that it works!

With a combination of a few variables, a loop and two for each the Flow will drill down from one individual and find every single person under them organisationally.
first stepsecond stepthird step

Was this reply helpful? Yes No
DR-30071856-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for providing the example, I'm trying to do something similar.

Could you please expand on the setp: "How many direct reports does this person have?".

I don't quite get what you are doing here. Thanks so much.

Was this reply helpful? Yes No