Forum Discussion
Gilbert Okello
May 09, 2017Iron Contributor
How to remove html characters when copying Email content to SharePoint List
I have a flow which copies Email content (Body) into a SharePoint list field (multiple lines text). The content gets copied with html tags. How can i remove the html tags? The content below wa...
Mikael Svenson
May 10, 2017Iron Contributor
One approach is to create a custom flow action which parses the HTML for you in order to grab the text. Or store the full e-mail as a .msg file in a doc lib - as SPO now has online viewer for msg files.
- Gavinash SirisenaMay 12, 2017Copper Contributor
Hello, sorry I'm just jumping in here because of your mention of the viewer for .msg files. How do we enable/access this?
- Mikael SvensonMay 12, 2017Iron ContributorHi,
the fact that I don't know how to save an email from a Flow to a lib as msg is one thing.. but if you put a .msg file in a modern library and click it, it will render in the browser.- Gavinash SirisenaMay 12, 2017Copper Contributor
You can ignore me! Tried it with a different email and it works beautifully...thanks!
- Gilbert OkelloMay 12, 2017Iron Contributor
Thanks Mikael Svenson. I realized that using Enhanced Rich Text as the field type works.
- Juliana MateSep 11, 2018Copper Contributor
I am trying to do a similar thing with the body of an email, but I'm not sure if the same settings for email, not Sharepoint. I don't see a Enhanced Rich Text option, but I'm new to flow, so not sure if I just don't know where to look. See screenshot for the problematic body text.
Body: <html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta content="text/html; charset=us-ascii"></head><body>text</body></html> - Mikael SvensonMay 12, 2017Iron ContributorNice :D