cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ken199191964
Frequent Visitor

Power Automate - Send the email subject and body to an excel file for a new email

Hi experts,

 

I am a new user for Power Automate. I have created a flow to save the email record to an excel file. 

It works good except the email body part is very hard to ready and understand.

 

Q1: For the email body, it is really hard for me to use it for analysis. What should I do to pick the email body content only?

Q2: For the email body capture below, how can I convert it back to normal email content? As I save several weeks data which I need to use it for further analysis. 

 

Data image of the email body:

ken199191964_1-1651887794743.png

 

 

 

Flow image: 

ken199191964_0-1651887617568.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
CraigStewart
Super User
Super User

There is an html to text function you can use here to turn the body into readable content before adding to excel.

 

I'm on mobile and can't get screenshot, but if you add the body output to that it will strip the html.

View solution in original post

1 REPLY 1
CraigStewart
Super User
Super User

There is an html to text function you can use here to turn the body into readable content before adding to excel.

 

I'm on mobile and can't get screenshot, but if you add the body output to that it will strip the html.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,619)