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:
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!