Add a loop after the first approval completes. In that loop put a Get Item action and a pause. After the Get Item check to make sure the required fields are filled. If not pause for a period of time and then loop and check again. Exit the loop after the required fields are completed. After exiting the loop do the next approval.
Pause = Do Until?
I have 15 required fields, do I need to add a separate Do Until for each field? Where in the loop is best to send a reminder email that there are blank required fields?
The Get item (not Get Items) needs to be inside the Loop. if its outside the Loop you'll never see the change in the value even if it happens. If you want to require 15 fields then you will need to have 15 conditions, but you won't need 15 loops. You can put all the checks inside each loop. I would suggest 15 parallel conditions that set 15 variables to 1 or 0 based on whether the value was set or not. Then add the 15 variables together and exit the loop if the value is 15.
Thanks for the advice, any chance you could dumb that down? I'm not 100% following.
Do I need 15 parallel "Do Until" conditions? How do I set them to be 1 or 0? How do I check for a sum of 15 to exit loop?
Sorry, let me clarify.
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!