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

[PowerFanAndreas]

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?

[VictorIvanidze]

Show your flow.

[PowerFanAndreas]

Hello Victor,

sure, it's really not very special.

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

Thank you so much for taking on the issue.

Best regards,

Andreas

[VictorIvanidze]

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.

[PowerFanAndreas]

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]

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.

[PowerFanAndreas]

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]

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.

[PowerFanAndreas]

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]

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.

[VictorIvanidze]

Hi @PowerFanAndreas,

have a look at this: ModifyAndForward flow

[PowerFanAndreas]

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!