cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DataDaemon
Level: Powered On

Create HTML table - list value formatting

I am trying to create an HTML table, which can be then displayed in an email. This isn't a problem, and is simple enough to do.

 

The issue I'm having is with the formatting of the values within the table.

 

The values are all pulled from a SharePoint list, and most values look as expected in the table, but all those values, which come from fields had selectable options are being displayed with lots of other info, which makes it unreadable.

 

As an example, in one cell, the value ought to be "Completed" but instead it's "{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"Completed"}"

 

Any guidance would be really appreciated.

7 REPLIES 7
Super User
Super User

Re: Create HTML table - list value formatting

Can you take a look and see if the there is another option in Dynamic properties for your column/field that is followed by the word "Value".  If so, try using it.

 

In my example, I have a SharePoint choice column called DueValue.  I would want to select DueChoice Value for inclusion in the table.

 

OptionTable.jpg

 

If this solves you problem, please mark your question as Solved.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
DataDaemon
Level: Powered On

Re: Create HTML table - list value formatting

Thank you for that suggestion, that works a treat for some of the fields.

 

However, some others don't have an "x value" version available. In instances such as those, what's the best way of dealing with it? Is it possible to generate a 'value' version?

Super User
Super User

Re: Create HTML table - list value formatting

What types of columns are are you having this issue with?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
DataDaemon
Level: Powered On

Re: Create HTML table - list value formatting

Interestingly all the 'choice' column types are fine apart from those, which allow for multiple selections.

Community Support Team
Community Support Team

Re: Create HTML table - list value formatting

Hi @ DataDaemon,

 

Does your problem be solved?

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

Could you please share a screenshot of your sharepoint list and details about each column's type in the list?

Could you please explain more details about your issues?

 

Do you have problem on the choice type column which allow for multiple selections?

 

I have made a test on my side,and couldn't find a solution to create an html table with a choice type column which allow for multiple selections.

 

I afraid that it is not supported in microsoft flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

 

 

Regards,
Alice Zhang

jpacettf
Level 8

Re: Create HTML table - list value formatting

@DataDaemon I am having the exact same problem. Did you ever find a solution to this?

MLM
Level: Powered On

Re: Create HTML table - list value formatting

I also have the same problem

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,681)