Retrieve email messages from Outlook - not producing variables

(1) Share

Report

Posted on by KW-03091517-0

Hello all!

I am attempting to use the 'Retrieve email messages from Outlook' action to pull data from the .Body for further analysis. However, when pull up the RetrievedEmail variable, the only option is '.count'. Can someone point me in the right direction to find .Body or .Subject? I am a bit lost.

Thanks!

Kris

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

KW-03091517-0 6 on at

Like (0)

Report

Apologies the image cropped in the original post:

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

Thats because Retrieve emails returns a "List of Outlook email mesagges"

When you click "More" you can see each message has .Body and other properties like Subject. So to get those use %RetrievedEmails[0].Body%. But that returns only the first emails .Body since it is index [0] of the list.

So if you get more than one loop the retrievedEmail list with for each loop and use CurrentItem.Body or CurrentItem.Subject

Was this reply helpful? Yes No
KW-03091517-0 6 on at

Like (0)

Report

Hi there!

Really appreciate your response - I should also mention that I am using the 'Subject contains:' for a unique ID to isolate to a single email. I wonder if this changes things?

Thanks!

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

@KW-03091517-0

It doesn't change the output from being a list. Retrieve email messages from Outlook -action will always return a list. So even if the "Retrieve email messages from Outlook" returns just one email then the output variable will still be list/array type.

So since its just one email in that list variable use: %RetrievedEmails[0].Body% or .Subject. You don't need to use loop since you know that the variable will always have list of just one item.

Was this reply helpful? Yes No
EH-18030801-0 4 on at

Like (0)

Report

Hello There

I have t he same problem and so far i couldnt find any acceptable repl to that. In my computer the variable doesnt show the ITEMS it only shows the summary. However when i look at the variable output i see the details when i click MORE option.

Anyone has any idea why is that happening?

Regards

Was this reply helpful? Yes No
Suggested answer

EH-18030801-0 4 on at

Like (0)

Report

I think i ve got a solution to that, try these expressions in any action to retreive the items, i suggest first put in variables as i described then use them anyway you like

Set Variable EmailBody
%RetrievedEmails[0]["BodyText"]%

Set Variable EmailSubject
%RetrievedEmails[0]["Subject"]%

Set Variable EmailFrom
%RetrievedEmails[0]["From"]%

Set Variable EmailTo
%RetrievedEmails[0]["To"]%

Was this reply helpful? Yes No