cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bren88
Helper II
Helper II

RE: Exporting sharepoint list to html table

See flow below, the column 'contact details' is of rich text hyperlink type and it's displaying html code and the column 'means of contact' is of Choice type and it's displaying each choice with extra info: {"@odata.type":"# ......

How can I get it to display only the value?

I really just want to copy this sharepoint list and display the records in a table format with rows and columns in a pdf file.

Do I need to create html table first? I'm just trying to get one step working first.

 

 

Capture9.PNG

5 REPLIES 5
yashag2255
Dual Super User II
Dual Super User II

Hi @bren88 

 

You do not necessarily have to create an html table but it will be easier that way. What is the column type of the contact details column? If it is plain simple text it will not append the extra tags. But if it is different then based on the data type, the tags will be added. 

 

If you can share more details on the data type, we might be able to assist you better with this. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hi @yashag2255 

 

'Contact details' column is of enriched rich text format (contains URLs)

'Means of contact' is of type Choice (up to 5 choices)

yashag2255
Dual Super User II
Dual Super User II

Hi @bren88 

 

You might have to use the convert html action to convert the rich text of html type to plain text and populate the html table with it.

 

For the choices, it seems that is a multi select choice column and that again returns an array of selected items. So you will have initialize a string variable and then add an apply to each to the choices column and append to the string variable with the value of these choices. 

 

Basically, you have to initialize an array variable at first for the SP items and then a string variable for the choices. Add an apply to each to loop over each SP item and then add the html to text action and pass the rich text column here. Now add another apply to each and then iterate over the choices column and in this loop add the append to string variable action to append all the multiselect values. Outside this loop add an action to append to array variable and populate the array in json schema like: 

 

{

"Column Name"  : "Select value from dynamic selector",

"Rich text" : "select output of rich text action",

"Multi Choices" : "select variable from dynamic content"

}

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

@yashag2255 I'm new to Flow and not familiar with JSON syntax, are you able to give more details based on the current Flow:

 

Capture9.PNG

@yashag2255   just trying to convert 'Contact details' first but not sure where to use 'Html to text' ?

Can't see the output to use in Create Html table?

Capture10.PNG

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (47,184)