azurenullazure-logic-appsemail-addressoffice365connectors

Azure logic apps 'o365 connector' action 'send approval email' returning null for property 'useremailaddress'. Why?


Azure logic apps 'o365 connector' action 'send approval email' returning null for property 'useremailaddress'. Why?

The Azure logic apps documentation for the 'office 365 outlook connector' shows that the 'ApprovalEmailResponse' object returns 'SelectedOption' and 'UserEmailAddress'. I get the correct value back for 'SelectedOption' but 'UserEmailAddress' always returns 'null'.

https://learn.microsoft.com/en-us/connectors/office365/#approvalemailresponse

How do I get the --> email address <-- of the user that selects 'Approve' or 'Reject' buttons in the email? If an email is forwarded to another person I would like to know who (email address) clicked approve or reject.

Setup

RESPONSE REQUEST IN OUTLOOK

AFTER RESPONSE HAS BEEN RECORDED

***This is what I get if I use the recommended settings mentioned in the replies below. For production we want to set "Use only HTML message" and "Show confirmation dialog" both set to "yes".


Solution

  • So... It looks like (in this particular action) the only way to get the email address of the person that clicks approve or reject is to not use HTML and to instead rely on using the action card, that is provided by the logic app action, in the email. With 'Hide HTML message' set to 'yes'. However... I was not able to find a way to render my custom card from the one provided in the email. As a workaround, I use markdown in the body of the action. Not great but looks the same as the HTML version I was going-for. If anyone can figure out how to edit/customize the card that is provided in the email by this specific logic app action. Please... let me and Microsoft (sarcasm) know.