Mutli Level Approval with Loop Until Required Fiel...

pedanticpad · ‎01-30-2020

Hi,

I have set up a multi approval flow, where the 2nd level of approval requires additional required fields to be filled. What I want to do is add some sort of a loop so that if the required fields are not filled it loops back and doesn't continue to the next approval level. Or even better approval is not available until all the required fields are met.

What's the best way to achieve this?

Pstork1 · ‎01-30-2020

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.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

v-alzhan-msft · ‎01-30-2020

Hi @pedanticpad ,

Please take a try with @Pstork1 's suggestion and let me know if your problem could be solved.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

pedanticpad · ‎01-31-2020

Hi,

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?

Pstork1 · ‎01-31-2020

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.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

pedanticpad · ‎01-31-2020

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?

Pstork1 · ‎01-31-2020

Sorry, let me clarify.

One Do Until based on a variable total reaching 15. Set the variable to 0 at the top of the loop. Then do a Get Item to get the item you need to check for required fields.
15 parallel branches inside the do until. Each branch checks to see if one of the fields is completed on the item you got. If it is add one to the variable you set to 0. This is your running tally of completed entries.
AFter exiting the parallel branches check to see if the variable is 15. If it is exit the loop. If not set a delay.
Loop around and do it again.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.