Hi, I have a couple of workflows that are not working as expected.
Given a already existing SharePoint List with 150 items in it. I want to get an approval for each of the items so I can compile a list of let's say attendees for a Christmas party.
Another similar workflow would be a scheduled Flow for a document library folder. Approvers need to extend the validity of certain documents on a yearly basis.
Adding an 'Send & Wait for an Approval' step into a for each Loop has certain implications I cannot mitigate:
- The loop pauses at the first element for approval 1, so in worst case (approval never gets a response) the flow is stuck on item 1
- Parallelization of the 'For Each' loop step (max. 50) messes up append to arrays, Strings, Filters, Joins (compose unaffected by this) etc.
The already solved thread suggested to set the for each loop to 50 parallel instances. In this case an already running flow can never be used to keep track of the current status of the loop (loop items of running flows cannot get debugged) and Lists and String joins do not work limiting my options.
Are there any solutions you guys have? This is in my case the typical use case. Documentation and YouTube Videos only show how to integrate Approvals into "when a new Item is created" type of scenarios.
