cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Community Support
Community Support

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

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (11,047)