cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerFanAndreas
New Member

E-mail format is not as in trigger e-mail

I need help with what should be a very simple task.

 

An incoming email is supposed to read a number from the email text and then send a new email, writing the found number (a customer number) in the subject.

 

With a formula I already get the number and it works as desired to write it also in the subject.

 

For all interested:
substring(trim(split(triggerOutputs()?['body/body'], 'Customer-No:')[1]),0,10)

 

[1] means the second half of the e-mail text, i.e. everything after the word 'Customer-No:' (belongs quasi to the split function)
0 means that subsequent text is used from the beginning, i.e. from the zero-th position (belongs to the substring function)
10 means that the text is used up to the 10th position (belongs to the substring function).

 

My problem now is that the email text from the original mail should be used exactly the same. But instead of writing the email text exactly as in the trigger mail, I get the mail in Outlook as body text without paragraphs. With the field body => triggerOutputs()?['body/body'] I would expect the text to arrive in Outlook exactly as I actually get it as output in Power Automate, that is with paragraphs.

 

My research shows that this action actually sends in HTML format. Both for the simple actions in my own mailbox and for e-mail actions for receiving or sending from a shared mailbox.

 

Does anyone have a solution?

11 REPLIES 11
VictorIvanidze
Community Champion
Community Champion

Show your flow.

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.
PowerFanAndreas
New Member

Hello Victor,

sure, it's really not very special.

I hope you don't let the German language bother you.

 

PowerFanAndreas_0-1661518407356.png

 

Thank you so much for taking on the issue.

 

Best regards,

Andreas

VictorIvanidze
Community Champion
Community Champion

The task is not easy. The only way I see is using MS GRAPH request to rewrite the Subject of ingoing email and then forward it.

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.
PowerFanAndreas
New Member

Okay, but what does "MS GRAPH request" mean? How could this look like? In the action "Forward email" the possibilities seem very limited to me.

VictorIvanidze
Community Champion
Community Champion

Before we start do discuss MS GRAPH, please do the following manually: in your Outlook find an e-mail in Inbox and click Forward. Modify the Subject and send the email. Check on receiver's end if you're satisfied.

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.
PowerFanAndreas
New Member

Yes, manually this is not a problem. I have changed the subject. The text looks the same as in the original mail, with paragraphs.

VictorIvanidze
Community Champion
Community Champion

Great! I just wanted to tell you that I think you can do the same in Power Automate only using MS GRAPH.

And unfortunately no, I have no time to show you in details what to do.

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.
PowerFanAndreas
New Member

I see, thanks anyway. Just saw that MS GRAPH is another service from Microsoft. Another topic. I would still like to find a solution to my problem in Power Automate.

VictorIvanidze
Community Champion
Community Champion

MS GRAPH is just an API.  In fact Power Automate is based on MS GRAPH. And you can do almost all that MS GRAPH can do, from the Power Automate - search for "GRAPH" here to find a lot of examples.

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.
VictorIvanidze
Community Champion
Community Champion

Hi @PowerFanAndreas,

have a look at this: ModifyAndForward flow

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.
PowerFanAndreas
New Member

Hi Victor,

okay, obviously there is a solution. Only it should also be possible to find an open solution. I therefore do not give up yet 🙂 But thank you very much!

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.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,257)