Help with Approval Flow with Variable Number of Approvers

[ehalsey]

I have built a Flow for a customer but am running in to a couple of issues.  I'm sure it's because I'm a newbey.  It is a multi-step approval Flow with a variable number of approvers.  I thought I'd be cleaver and use an array and a Do Until Loop.  It appears to generate the right number of approvers only some of the time.  The Do Until Loop has instance data for all approvers some of the time but a lot of the time it only has one Loop instance visible in the Run History GUI.  I must be doing something wrong but I can't see any Loop instance data from the csv download even when there is only 1 loop instance which makes it difficult to debug.

My questions are:

1. How do you recommend debugging actions inside of a loop?
2. How do you recommend debugging Flows if they are outside of the csv download window (max 100) and what would you recommend a business user do to audit/debug their SharePoint related Flows?  Their doesn't appear to be a link from SharePoint to the Flow Run History.

Please help me out if you can even if it is that Flow can't do this so I can let the customer know one way or the other.

[sergeluca]

Hello,

can you provide better resolution pictures ?

Kind regards

Serge Luca

[ehalsey]

@sergeluca is this better? Original Screen Capture or this one Google Drive copy

[sergeluca]

yes,

I'm not sure I fully understand your flow, but did you know that you can store a list of users in the Start an approval action without having to create a loop ?  just specify the setting "everyone from the assigned list" because the approval has an internal loop. If someone rejects, the approval will return reject automatically...and will stop.

Does that help you to keep it simple ?

Serge Luca

 

[ehalsey]

Thanks for the reply.  Yes I was aware but we have to use this approach.  I don't recall the reason off hand but the other approach didn't satisfy the requirements. 

[ehalsey]

@sergeluca I'm hoping someone can help with the following questions.

1. How do you recommend debugging actions inside of a loop?  The download CSV option doesn't appear to contain the loop instance data i.e. the values of the set variable actions like it does for actions outside of a loop.
2. How do you recommend debugging Flows if they are outside of the csv download window (max 100) and what would you recommend a business user do to audit/debug their SharePoint related Flows?  Their doesn't appear to be a link from SharePoint to the Flow Run History and asking a typical user to go the Run History (not sure if they'll even have access) to try and view the status of a workflow with only a date/time as a reference would be bananas.

I'm OK if the answers are "not possible today".  I just need to get an answer back to the client so we can look at other options.

Thanks again for your replies.

[sergeluca]

ok here is what I do : I always, always, always 🙂 have a log list in SharePoint where I store my loops values

[ehalsey]

Thanks @sergeluca.  Hoping we don't have to build MS Flow infrastructure related lists, etc. but something I could suggest to the client. 

[sergeluca]

No it should not be a gas factory; a single list should be enough... 🙂

Kind regards

Serge Luca aka "Doctor Flow"

[GabrielStJohn]

Hello, @ehalsey!

Have you had an opportunity to apply @sergeluca‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

[ehalsey]

@GabrielStJohn I have reviewed and still interested to hear from others.  I appreciate @sergeluca response but it is not a great option.

[haniel]

@sergeluca,

In your example, you are showing two approvers for the Start an Approval action.  I did some testing and found that once I exceed 3 approvers, I get the following error:

InternalServerError. The request failed. Error code: '500'. Error Message: 'BadGateway'.

In my scenario, I have a variable number, some being more than three.  Have you seen this scenario?

Regards,

-Haniel