Answered

Way to extract 100% output of a iterations from a Do until

(0) Share

Report

Posted on by Coffee654

I have a flow that uses the actions take and skip inside a Do Until to process an array. This is because the API that I am sending the info to does not allow me to send 100% of the array in one call (hence the need to use skip and take to send the Array to the API in blocks).

The issue is that I would like to do a completeness test that will allow me to compare the original Array with all the output from my Do until in order to make sure I actually sent to the API 100% of the original Array. To do this, I need to somehow extract the output of all the Do Until's iterations.

Let's assume I have the following array:

If I have a Do Until that uses take and skip and process two words at a time, I will have three iterations of the Do Until (a,b + c,d, + e,f). Right now, what I have tried is using an append to string variable inside a Do Until that will grab each iteration output. But when I use the appended variable in other actions outside the Do Until, I only get the first iteration or in this case, if we use the pic above as an example: I only extract this:

When ideally my append to string variable inside the Do Until will be able to get me this after appending of iteration of the Do until:

These are the actual actions in my flow. The ComposeDoUntil uses the take(skip( formula to extract the corresponding block of info from the array and my append to string is supposed to take the compose output and append each iteration's output:

What actions do I need to create in order to extract 100% of all the iterations of my Do Until? Any help will be appreciated. Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @Coffee654

Based on the solution I provided here Make HTTP calls inside loop that filters array? - Power Platform Community (microsoft.com) you can further extend that to include a variable for an array above the apply to each. Create a copy of the array in a compose and then update the original array with a union of the compose and the compose batch (using the skip/take). You can then output the array outside of the apply to each to double check everything is there as required.

Set variable is:

union(outputs('ComposeCopyVariable'),outputs('ComposeBatchesBySize'))

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts. Thanks

Was this reply helpful? Yes No
Coffee654 14 on at

Like (0)

Report

Awesome! Thanks, @DamoBird365. I will be trying it this this week and as soon as I’m able to implement it I will let you know and accept it as solution.

Was this reply helpful? Yes No