I want to join all values in "Apply to Each" to a value after Apply to Each.
In my scenario:
In Apply to Each loop, create new values by Data Operations - Compose.
After the Apply to Each loop, create a value by join all values created in the loop.
This scenario can use to creating summary from some outputs from services.
Solved! Go to Solution.
Could you please explain a bit regarding "Join all values" here?
Have you checked the following article?
Could the HTML Tables, or the CSVs table helps in your scenario?
Do you mean to add them all together?
"Join all values" make from some values to a value.
Yes, the blog "Build flows with HTML Tables, ..."
So, I want to do same with Apply-to-each.
Step 1. Get a array value.
Step 2. Create new value in Apply-to-each from each array items.
Step 3. Create a new value from the values in Step 2 after Apply-to-each.
Step 1. Get a array value by Excel - Get Rows.
Step 2. Create new value in Apply-to-each from each Excel Row item
by Data Operations - Compose, concat first column and second column.
Example: "Col1 Col2 / Row 1"
Step 3. Create a new value from the values in Step 2 after Apply-to-each with comma seperate
Example: "Col1 Col2 / Row 1, Col1 Col2 / Row 2, Col1, Col2 / Row 3"
Thanks for the update.
I will try some tests, and share the result later.
Appreciate your patience.
Has this been solved yet?
Is it possible to get the summary of an apply to each loop?
I processed an array in the loop, then I want to send all the resulting values in one email. Not each result in 1 email.
I have a similar use case.
Get a list of items from a REST API call, apply to each to perform some string manipulation and then I want to construct a string representing all the processed strings.
1. Compose: "@createArray('a','b','c')
2. Apply to Each: Output from 1
2.1 Compose: "concat(item(), '-1')"
3. Join: Output from 2.1, ";".
Step 3 throws an error saying the output from 2.1 is null.
Ok found the solution, actually posted here: https://powerusers.microsoft.com/t5/General-Flow-Discussion/Sample-build-a-string-from-compose-outpu...
I am using the technique you describe but it is outputting the formula string and not the underlying variable e.g. ["@Join(outputs('First'),'')","@Join(outputs('First'),'')","@Join(outputs('First'),'')"]
My formula is @Join(outputs('First'),'')
Any ideas what I am doing wrong? Your help would be greatly appreciated.
I needed to send email to users only once and not repeat their email address.
This is what I have done:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!