%RetrievedEmails[0].From% (Outlook Message Datatype Property .From) reporting as bad syntax

(0) Share

Report

Posted on by MichaelAnnis

5,727 Moderator

I clearly have captured .From in my Retrieve Emails:

Therefore, %RetrievedEmails[0].From% should give me the from e-mail address.

I am trying to use a Switch Case, but every time I try to get .From from an Outlook Email Message, it fails.

I have tried to work around it by getting %RetrievedEmails[0]% as it's own variable %CurrentEmail% which was a success and it was read as an individual Outlook Message; however, when I tried to get %CurrentEmail.From% it gave me the same syntax error. Any syntax error will not allow you to run the PAD flow.

Anybody know why .From is not working when it is clearly stated as a property in the first image and listed as an available property here:
https://docs.microsoft.com/en-us/power-automate/desktop-flows/datatype-properties#outlook-mail-messages

Any help would be appreciated.

Thanks,

Mike

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hello @MichaelAnnis

I could retrieve the from email address using %RetrievedEmails[0]['From']%.
However, I have to agree with the feeling of strangeness you felt.

%RetrievedEmails[0]['From']% %RetrievedEmails[0].Date% %RetrievedEmails[0].Subject%

I wonder why ".From" cause syntax error, while ".Date" or ".Subject" is working with no problem?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

That worked perfectly. Thank you @Anonymous . I have no idea how you figured that out. I tried so many different things. Thanks again.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @MichaelAnnis

Good to hear it worked. 🙂

How I figured it out:

[1] Use any action to refer infromation of the current Email message, such like "Display message" for example. Click {x} icon to bring "Select variable" fly-out menu.

[2] You will find the variable "CurrentEmail" which type is "Outlook email message" and storing email properties such like .To, .Cc, .Bcc, .Body, etc. Of course there is property .From as you already know.

[3] Choose property .From and click [Select] button.

[4] Now we can see the actual syntax of .From property is %CurrentEmail['From']%.

That's it. Thank you.

1 people found this reply helpful.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Did not know you could do that from that window...That's cool. I've always directed people to the variable pane on the right to find that info. Thanks again.

Was this reply helpful? Yes No