How to show the concated variables in the form of list in email body

[Ashwinreddy]

Hi, I am having a requirement to show the list of names comming from get rows in the flow and those are comming as comma separated but i want it as an list way and it should be in email. 

Scenario: the names from the rows comming as Rahul,David, Mani in the email

but iwant as 

• Rahul
• David
• Mani

please help me on the flow and i have attached the flow i created where the variable highlighted store values and i have added directly in email.

[fchopo]

Hi @Ashwinreddy 

You could to the following in a compose action:

concat(concat('<ul><li>',replace(variables('name_of_string_variable'),',','</li><li>)),'</li></ul>')

As we are using HTML formatting, you should also configure it in the Send email action.

Hope that helps!
Ferran

[Kaif_Siddique]

Hi  @Ashwinreddy, 

Here is a sample flow. Customize it as per your need.

split(outputs('Compose'),',')

Let me know if any queries.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

Regards

Kaif

[Ashwinreddy]

Hi Thanks for the response tried as above but the out put was not expected and the variable cannot be defined inside the loop in my case, please suggest anything missed on my end

[Kaif_Siddique]

I am not sure whether steps are followed or not in shared screenshot.

I would suggest you create a new flow. Test and analyze the flow which is shared by me. Then apply same logic in your flow.

Also sharing a reference link:

https://powerusers.microsoft.com/t5/General-Power-Automate/Expand-multi-answer-form-list-for-an-emai...

Regards

Kaif

[Ashwinreddy]

Hi Kaif,

You are correct but in my case im trying to get from apply to each and send outside apply to each,

as shown in the below image if the loop has 25 records and 2 of them satisfied and entered the condition where the first set variable and compose shows the name and the same needed in second set variables down but in my case im not getting second name but im shown only first value

[Kaif_Siddique]

As i can see, you are using Set variable to assign value. But Set variable will overwrite the current value in Apply to each loop. That's why in your case you are not getting second name but only first value.

I would suggest try Append to string variable as below.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

Regards

Kaif