The flow is supposed to work like.
File is uploaded > wait for First Approver & Second Approver fields to be filled out > send email to first approver > Approved > send emailed to second approver > Approved > send email to all parties.
When I run the flow, it seems like it just skips over the do until, and then fails at the first email because there is no value in the "First Approver" column yet. Am I doing something wrong? Also I should note: If I put a delay within the Do-Until, it just hangs there forever, and the interval is set to 60 and 1H
Could you please share a bit more about your SharePoint library?
Are the First Approver column and the Second Approver column the Person or Group type column within your SharePoint library?
I think there is something wrong with your “Do Until” action, I have made a test on my side and please take a try with the following workaround:
Add a Condition 2, left input box set to SelectedOption dynamic content of “Send approval email 2” action, right input box set to Approve, within middle drop down, choose is equal to.
Within “If/yes” branch of Condition 2, add a “Send an email” action.
The flow works successfully as below:
The First and Second Approver columns are Person or Group Type. I modified my formula and changed the flow per your instructions, and it still fails after about 30 seconds or so. I'm testing it by leaving both first and second approver blank initially. I noticed in the formula you gave me, it evaluated the "First Approver" column twice. I changed it to check both and still got an error.
If your First Approver column and Second Approver column are both Person or Group type, please consider take a try to change the formula within "Do Until" action of the flow that I provided into following formula:
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!