Answered

Using a choice field in HTML Table

(0) Share

Report

Posted on by chrissmf2023

Im very new to Power Automate but am learning slowly . I have a list which I am attempting to create a HTML table from to e-mail out.

The HTML table I can create which works fine (i've followed a useful Youtube video..).

However one column in my list (Change Req Status) I have had to amend to "single line of text" as a pose to the original (and preffered) "Choice" due to the HTML table displaying a list of code including the value, I am assuming there is some JSON formatting I can enter to remove and only display the value.

Any help would be appreciated.

Thanks

I have the same question (0)

All responses (3)

Answers (1)

fchopo 8,001 Moderator on at

Like (0)

Report

Re: Using a choice field in HTML Table

Hi @chrissmf2023

Please, have a look at this post: Solved: Using Choice Values from Sharepoint list in email - Power Platform Community (microsoft.com) It shows how to read a multiple choice value and append them to a single variable that is used to send in an email.

Hope that helps!

Ferran

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (2)

Report
Re: Using a choice field in HTML Table

Hi @chrissmf2023,

Do you want to display only Value of Choice column in HTML table?

Could you please tell that if this Choice column allows only single select or not?

If it allows only single select, you just need to take a look and see if the there is another option in Dynamic content for your Choice field that is followed by the word "Value". If so, try using it.

Note that in my scenario I have a Choice column named CarAstatus.

If it is a Choice column allows multi select, please try to use the following formula:

join(xpath(xml(json(concat('{"body":{"value":', item()?['Choicefield'], '}}'))), '/body/value/Value/text()'), ', ')

Was this reply helpful? Yes No
bmaraist 11 on at

Like (0)

Report

Re: Using a choice field in HTML Table

I've been looking for a solution for multi choice combo box to HTML table for over an hour and your formula worked. Thank you!

Was this reply helpful? Yes No