web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get values from Multip...

Power Automate

Unanswered

Get values from Multiple-choice field and Send email

(0) Share

Report

Report

Posted on by esjimenezp

485

Hi Community,

I'm doing several tests but not successfully 🙁 at this time, I have a SharePoint lists with a column of multiple selections enabled,

Then I added the Select action, to only add the specific column that I need to send an email.

Also, I added the Create HTML

Then, I added a style table

Finally, the Send an email action

The final result, how can I get only the Value itself of the field, for example the value of the column Growth Method? all help will be appreciate, thanks.

I would like to be the output like the below image

Kind regards 👋

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @esjimenezp ,
because get items return array you can't simply the value in select I have made a simple test to achieve this you can refer to this screen short.

replace(replace(replace(join(body('Select'),','),'{"test":"',''),'"}',''),',',';')
this formula combines all the test value which is a multi-select field In SP list.
try this and let me know if you need any help.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
esjimenezp 485 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @anandm08 for your help....

How can I do this but directly from Select action? because in my flow I don't use the Apply to each action, example, look at the Output of the Body of the HTML Table
Thank you for your help.

Kind regards 👋

Join the conversation