Answered

Email to list shows all html data and not just text.

(0) Share

Report

Posted on by GrahamRoberts

How do i strip all the HTML data out of an email so that when the body of the eamil gets added to a list it doesnt show all the <> stuff?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Dev_Nikhil 225 on at

Like (0)

Report
Copy link

Link copied!

Hi @GrahamRoberts

As Per My Knowledge of Microsoft Flow you have Problem in the Getting Email Data into the List and Specifically you have the Body Part of your mail into the Html Format, right ?

Actually earlier i also had faced this Issue, You have to do small change in the Column Which you are Storing the Body of your Email make Column "Multiline" and also Choose the "Rich Text Box".
I am 100% Sure that this Approach will solve your Problem. However oi this not works fell free to ask.
As you can see in the Picture one is Simple Multiline Column with "Plain Text" and Last one Column is with "Rich Text box" setting.

Thanks

Was this reply helpful? Yes No
GrahamRoberts 12 on at

Like (0)

Report
Copy link

Link copied!

Great. That seems to work for list just need to figure out how to get is done for planner.

Was this reply helpful? Yes No
Dev_Nikhil 225 on at

Like (0)

Report
Copy link

Link copied!

Hi @GrahamRoberts
Can you share the more detailes or the Image of the Flow Specific process portion where you have this issue ?

Was this reply helpful? Yes No
GrahamRoberts 12 on at

Like (1)

Report
Copy link

Link copied!

So currently this is my flow so that when a web equiry is email it populates a list.

This the flow which takes the infor from the
list to create a Planner entry
As in above reply i have managed to sort the HTML issue in list but still get the HTML in the Planner as below.

Was this reply helpful? Yes No
Verified answer

Dev_Nikhil 225 on at

Like (0)

Report
Copy link

Link copied!

Hello @GrahamRoberts
I tried that Flow and get the solution !

You can solve it by adding just one step in the flow you have to Convert the HTML to plain text via just one step before you Update the task details see the Image below

You have to put the value of the email body into the converter for to convert the HTML text to the Plain Text.
(In my case i have Taken the Body of the Email, In your case you can take the "Event details" i have Double checked i assure you that it will work on both ways on Email Body Content and in Sharing list Field too.)
at last use the plain text Dynamic Content where ever you want to use.
(In my case i just used the Only plain text Content but in your case you have to replace it with the Event )
details

Thanks

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @GrahamRoberts,

I agree with @Dev_Nikhil's thought almost, I think a "Html to text" action could achieve your needs.

I have made a test on my side and the flow's configuration as below:

The flow works successfully as below:

The created item in my SharePoint list as below:

In addition, I think it is not necessary to configure "Rich Text box" setting in your SharePoint list. If you want to convert the body (html text) of the email into normal plain text and fill it into your SharePoint list column, you could also use the "Html to text" action to convert the html text into normal plain text:

Best regards,

Kris

Was this reply helpful? Yes No
GrahamRoberts 12 on at

Like (0)

Report
Copy link

Link copied!

Thank you all for your help!! This has worked and has been working well for a few days 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Your solution works perfectly well. However, in my company I can't use it because of Data Privacy issues with this connector. Is there any other solution around that you can suggest?

Was this reply helpful? Yes No