So, I have finally got my stations in an array variable, and now I want to loop through and print the station names in the body of the email step. In the attached photo you can see the part of the email body I am trying to loop through things. I have not done this before so here is what I am trying

// Dynamically populate station names

foreach(var stationName in Station Names) {

@{stationName}

</div>

}

Station Names is the variable that hold the station names, and of course stationName being what should be printing the station names. am I headed in the right direction?

Categories:

General topics

Hi @Bacon1,

No JavaScript needed for what you want to accomplish, consider following flow design:

I simulate your input data using first compose
In an Apply to each, I build div in a compose
Outside apply to each, I use an advanced Power Automate trick to get an array of DIVs by calling outputs of compose belonging to Apply to each and use join() to convert it to string. Power Automate won't propose it in Dynamic contents outside of the Apply to each, you have to write it as expression manually.

Now, you've just to replace your "Station Names" variable in your mail body by last compose outputs.

[Edit] You can also achieve this without using loop:

Select From: outputs('Data')

Select map: item()?['Name']

"No loop all DIVs" compose expression:

concat('<div style="width: 17%; border-bottom: 2px solid rgb(111, 249, 57); padding-bottom: 7px; text-align: center;">', join(body('Select_Names'), '</div><div style="width: 17%; border-bottom: 2px solid rgb(111, 249, 57); padding-bottom: 7px; text-align: center;">'), '</div>')