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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (2,993)