cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StillLearning
Frequent Visitor

Create CSV vs HTML Table - Need to make all text visible in SharePoint multi-line column - how to format in flow

hi all,

 

I am desperately trying to find a way to format the view of a rich text multiline SharePoint column so that the list displays all of the text in the column. I have  a flow that creates a HTML table and that table is then input into the multi-line column (in essence, the column is updated by re-inserting the HTML table). This works fine, however the column only shows the first few rows before it 'fades out' in the list. I need it to display all text.

 

I have tried column formatting, which doesn't work (shows the html formatting). I have tried using 'create csv table' in the flow instead but then I can't seem to have the column view look like a table. 

 

I don't need a fancy table, but because the content in the table will vary in length it needs to be in a table format in order to make it readable. 

 

Any thoughts or suggestions ????

 

1 REPLY 1
Jay-Encodian
Community Champion
Community Champion

Hey @StillLearning 

This is really a SharePoint question not Power Automate.

I expect you'll need to create a custom formatter for either the column or view depending on your full requirements, check out the following references:

Column formatting: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#formatti...

View formatting: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/view-formatting

Examples: https://pnp.github.io/sp-dev-list-formatting/

This might be a good starting point: https://thechriskent.com/2019/01/16/applying-column-formats-to-multi-line-text-fields/

HTH

Jay

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,634)