Answered

Unable to get the correct email body when using When a new email arrives (V3)

(1) Share

Report

Posted on by Georgia_H

Hello, need help to understand why i can't get the correct email body with email address from the email i received in Outlook. This is how the email looks like in Outlook.

This is the flow Image A: I need to extract the requestor email address from the email received in Outlook. But when i download the Output in "When a new email arrives V3" the below is what i see. See Image B:

Image A:

Image B:This is what i see in the Output of When a new email arrives V3. There's no email being captured. The content changed from what i see in Outlook.

Please, can anyone help to enlighten me on this issue? Which step did i do wrongIy. I have been struggling for a week now.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (2)

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Georgia_H ,

Here's the flow finding the starting position of characters using indexof() and then using substring() to get the desired text.

Compose // find the first "(" plus 1

add(indexOf(body('Html_to_text'), '('),1)

Compose 5 // find the ")"

indexOf(body('Html_to_text'), ')')

Compose 6 // get the email adddress

substring(body('Html_to_text'), outputs('Compose'), sub(outputs('Compose_5'), outputs('Compose')))

Compose 2 // find "Power BI Report" plus 16

add(indexOf(body('Html_to_text'),'Power BI Report'),16)

Compose 3 // find "Manage in Power BI"

indexOf(body('Html_to_text'),'Manage in Power BI')

Compose 4 // get report title

substring(body('Html_to_text'),outputs('Compose_2'),sub(outputs('Compose_3'),outputs('Compose_2')))

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Georgia_H ,

I modified my flow with an edit in case didn't see the modified version. The report title may need some help because in testing I didn't have the buttons, but I think the framework will help you keep going; you may need to modify the last indexof().

Was this reply helpful? Yes No
Georgia_H 29 on at

Like (0)

Report

Thanks Tom for the checking. Unfortunately my issue is different.
What is see in Outlook email is not what is translated in Power Automate using "When a new email arrives (V3)".

This is the email i received in Outlook: There's an email address from the requester Manu.
This is what i see in the Output of "When a new email arrives V3" in Power Automate. No longer see the email address of Manu. Hence the "get Requester email" step could not find any email.
I need help to understand why the format changed.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Please show the full body part:
"body":"<html etc.

Was this reply helpful? Yes No
Georgia_H 29 on at

Like (0)

Report

Here you go.

BODY_HTML.docx

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,073 on at

Like (1)

Report

There is no requestor email address at all.
1) (Dirty method) You can retrieve the address by user name from the Active directory
2) To suggest something else I have to have the whole access request message. Could you send it to test1(at)testivasoft.com ?

Was this reply helpful? Yes No
Verified answer

Georgia_H 29 on at

Like (0)

Report

Yes, you are right. There's no email address at all. That is very strange because from Outlook i could see the email address. See snippet.
As a workaround, I have tried the first approach by Search for User V2. I managed to resolve the issue for now. Many thanks for your suggestion. Kudos to you 😊

Was this reply helpful? Yes No