Answered

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

Like (1) Share

Report

Posted on 16 Oct 2023 12:44:24 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.

All responses (7)

Answers (2)

Verified answer

Georgia_H 29 on 19 Oct 2023 at 01:47:22

Like (0)

Report

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

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 😊
Verified answer

VictorIvanidze 12,216 on 18 Oct 2023 at 15:07:40

Like (1)

Report

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

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 ?
Georgia_H 29 on 18 Oct 2023 at 08:26:12

Like (0)

Report

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

Here you go.

BODY_HTML.docx
VictorIvanidze 12,216 on 17 Oct 2023 at 09:47:55

Like (0)

Report

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

Please show the full body part:
"body":"<html etc.
Georgia_H 29 on 17 Oct 2023 at 02:17:57

Like (0)

Report

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

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.
trice602 13,768 Super User 2025 Season 1 on 16 Oct 2023 at 13:26:47

Like (0)

Report

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

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().
trice602 13,768 Super User 2025 Season 1 on 16 Oct 2023 at 13:02:54

Like (0)

Report

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

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')))