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.
