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?
