cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Creating HTML table with Choice column

Hello,

 

I currently have a concern when creating an HTML table through Flow. One of my SharePoint lists contains a Choice Column. I'm trying to pull the value into a HTML table but the format of the value appears like so:[{"Id":1,"Value":"CHOICE1"}]. I would like to know how to only pull 'CHOICE1' instead of the entire string. In flow, the expression I used to pull this information is item()?['Choice_Column'].

 

Thank you.

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Creating HTML table with Choice column

Hi @ huynhhere,

 

Could you please share a screenshot of the configuration of your flow?

 

You could use the expression item()?['Choice_Column']?['Value'] to get the vaue of a choice field.

 

I have made a test on my side,and I have create a flow as screenshot below:

Capture.PNG

 

The flow would run successfully to create the html table as below:

Capture.PNG

 

 

Regards,
Alice Zhang

Highlighted
Frequent Visitor

Re: Creating HTML table with Choice column

Hi, 

 

I have the same issue and didn't get where I can add the code.

Could you support?

 

Thank you.

Maria

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (9,676)