Answered

Issues working with Exchange mail message properties

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have encountered an issue working with Exchange mail message. While accessing properties From and To it displays Syntax Error, as seen on picture below. I can access the same way all the other properties, for example %RetrievedEmails[0].Date% with no error message. I'm not sure what is wrong there. The To property is a nested list, so I guess I would need to access like this way %RetrievedEmails[0].To[0]% to access the first value of the property. But From property should work like the others, since there is no hint in documentation about otherwise.

Thank you for the assistance on this issue. Below are reference links to the documentation from which I drew.

References:

https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/exchange

https://learn.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#exchange

https://learn.microsoft.com/en-us/power-automate/desktop-flows/datatype-properties#exchange-mail-messages

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

%RetrievedEmail.[‘From’]% or something idiotic like that.

what you can do is click the {x} on the field input that shows you all your variables. Next to each one, if they have properties associated with them, there will be a drop-down arrow. Click that and you can select the “From” property, and it will put in the right syntax for you.

good luck!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

So I figured this out by creating new variable and assigning to it value of the Exchange list.
In pseudocode something like this:

new_var = %RetrievedEmails[0]%

Then I was able to get to the properties of the new_var list a figure out the correct syntax, which is %RetrievedEmails[0]['From']%. I have no idea, why this particular property has to be written in that format, and not like the other properties, for example %RetrievedEmails[0].Date%.
There is some serious magic behind the curtains.

Was this reply helpful? Yes No