Answered

Do Until Loop Where Manager = a certain person

(0) Share

Report

Posted on by Andrew5715

Hello!

I need help figuring out how to build a flow that takes a people picker name in SharePoint and sends an email to their manager and continues up the chain of managers until it reaches a specific person.

The flow should stop after it reaches that final manager and sends them an email (but not go any higher in hierarchy)

I've tried a few different approaches but always end up getting stuck in some sort of endless loop or it's only pulling the first manager and doesn't keep going.

Anybody do something similar to this before? Hoping to get some help.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@drewdev how would you determine when to stop in the chain? So who is the last manager?

Was this reply helpful? Yes No
Verified answer

AWorley 414 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,
In order to iterate managers through a ladder you will also have to include the "get manager" action and loop across a user profile that is overwriting a variable. The "starting Email" variable is the email address of who ever would kick this off. Can be dynamic or statically typed.

The flow works as shown here:
Do until display name of Manager is equal to the displayname of the final manager.

Initialize variable Email with Test@test.com > Get the user profile > Get their manager > Set the manager's mail as the User profile > Repeat until the Displayname is equal to the final manager. (can do email address too).

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@drewdev

Can you post a screen shot of your Flow? With that, it will be much easier to assist.

Was this reply helpful? Yes No
Andrew5715 30 on at

Like (0)

Report
Copy link

Link copied!

This was my latest attempt after finding a process similar listed on the forums

Was this reply helpful? Yes No
Andrew5715 30 on at

Like (0)

Report
Copy link

Link copied!

Awesome let me try and give this a shot

Was this reply helpful? Yes No
Andrew5715 30 on at

Like (0)

Report
Copy link

Link copied!

each person submitting will eventually report up to a certain manager level. so I have the final manager's email that can be used to loop until. So the idea is the flow keeps emailing each manager, gets to the final manager - sends one final email and then stops.

Was this reply helpful? Yes No
Andrew5715 30 on at

Like (0)

Report
Copy link

Link copied!

I have mine setup similar to yours, but I'm noticing that it keeps looping even though my variable is = to the final manager's email.
So it seems like the DO until piece is not being triggered no matter how I write it.. Using Contains or Equal to

Was this reply helpful? Yes No
Andrew5715 30 on at

Like (0)

Report
Copy link

Link copied!

This is the newest iteration that works and loops.. but endlessly even though the variable equals the correct final manager email. Not sure why it's not stopping like I would expect it to

Was this reply helpful? Yes No
AWorley 414 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,
I relooked into it and came up with a solution to the end stop.

1. Initalize a variable and set the final manager as that value.
2. Set the Do Until statement to "Get User Profile " IS EQUAL TO" varFinalEmail".

This exited the loop for me.

Was this reply helpful? Yes No