cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

How can I use the content (values) from a multiple value-column in an email-message?

When I use the values (out of a multiple values column)  in a email-message the Power Automate automatically turns to "for each value" .  That is not what I want. I  want the values  (separated by a comma)  as a text in the message.  Is there somebody who can help me with a solution? 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Hi @PowerKees ,

 

I think that your topic is more related to PowerAutomate Community, but here is my answer:

 

I understand that you want to convert the values of a specific column to String and insert this string in the body of an email.

 

gabibalaban_0-1603720223749.png

Please follow my flow:

        First of all, I initialized a variable (yourText) to keep the temporary string 

        Then I took 5 items from a random lists of mine.

        After that, I iterate through getting the value of the column desired and append it to the the temporary string.

        At the end, only for testing propose, I initialized another string variable with the current temporary string value.

 

Hope it can help you !

 

  

View solution in original post

2 REPLIES 2
Super User II
Super User II

Hi @PowerKees ,

 

I think that your topic is more related to PowerAutomate Community, but here is my answer:

 

I understand that you want to convert the values of a specific column to String and insert this string in the body of an email.

 

gabibalaban_0-1603720223749.png

Please follow my flow:

        First of all, I initialized a variable (yourText) to keep the temporary string 

        Then I took 5 items from a random lists of mine.

        After that, I iterate through getting the value of the column desired and append it to the the temporary string.

        At the end, only for testing propose, I initialized another string variable with the current temporary string value.

 

Hope it can help you !

 

  

View solution in original post

Thank you so much for your help. It works!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (65,165)