1

I have a Power Automate flow set up to copy email to a SP list, the column is set to rtf so that the list just has the email body rather than all the (I'm guessing) HTML stuff plain text gives but I'd like to format the column so the contents have just one font and size.

I'm not at all familiar with JSON and tried a few things but can't seem to get the column to change font.

Is there a way of doing this and, if so, could I be given an example of the JSON to use?

Thanks

2 Answers 2

1

Unfortunately, it is not possible using SharePoint JSON formatting.

SharePoint JSON formatting does not support applying JSON to Multi-Line Text column with enhanced rich text.

enter image description here

Microsoft official documentation: Use column formatting to customize SharePoint


You can try adding CSS styling in Power automate flow itself before adding email body to SharePoint list column.

Update from comments:

Check HTML to Text action in Power automate for extracting text from HTML email body.

Microsoft documentation: Html to text action in Power Automate

2
  • Thanks Ganesh that’s a great straight forward answer. How would I go about adding CSS styling? Or there a way of extracting just the text from an email body?
    – eagleaye
    Oct 23, 2023 at 17:01
  • Check HTML to Text action in Power automate for extracting text from HTML body. Oct 24, 2023 at 6:38
0

You can use "Html to text" action to convert the body content of the email to text. enter image description here

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.