HTML to Sharepoint list

[KellyHickman]

This seems a far stretch, but I'm asking anyway...

I have an variable/expression built into my PowerAutomate flow that recognizes paragraph breaks in a field. The field value is fed to a Sharepoint list with the paragraph breaks translated to html. The column type has to be rich text to accept the text alignment. Sharepoint column rich text type does not support advanced json code formatting, so when json is added to the rich text column it shows the html at face value, which is a mess.

I really want to have the column show a color if there is a value and no color if the field is blank. I can't do this to the rich text column without it showing the face value html in the column and I can't change it to a plain text type because it loses the paragraph breaks from the flow.

I'm wondering if there is a way to manipulate the data in the flow to remove the html before it feeds to the SP list so I can use a plain text type but still have the value recognize the paragraph line breaks.

Seems impossible but there are experts here that are insanely smarter than I am.

[David_MA]

I am not completely understanding what you are doing, but if you want to replace <br> in HTML with a line break for a text field in a SharePoint list, use this expression to generate the line break:

decodeUriComponent('%0A')

Then I suppose you could use something like this to find and replace them in your HTML:

replace(outputs('Get_item')?['body/HTML'],'<br>',decodeUriComponent('%0A'))

This will just add one break, so you may want to use concat to put two line breaks.

[KellyHickman]

Thank you David, so if I currently have this as my expression

replace(outputs('Get_response_details')?['body/r4ab453db95514931af404042ffe9bbbc'],variables('Line Break'),'<br>')

what would your suggestion look like as a replacement for this expression with multiple line breaks? There may be more than one. I don't understand replacing the body/r4ab453db95514931af404042ffe9bbbc of the expression with body/HTML.

[David_MA · Accepted solution]

I am not really sure. I thought you said you had HTML code and the issue with populating it into a SharePoint text field is that the <br> values where showing up in the text field. If so, I would pass wherever this HTML is coming from through a Compose action, then when you populate the SharePoint list (I assume that is what the image above is), use the expression to replace them from the body of the Compose action.

[KellyHickman]

This absolutely worked!! THANK YOU!

[David_MA]

Awesome. Glad it worked!