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.
***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".
2
Answers
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.
After reproducing from our end, we understood that the messages which are recorded as HTML messages aren’t capturing all the responses. For this, Make sure you have the below parameters set
Hide HTML messageto ‘yes’.RESPONSE REQUEST IN OUTLOOK
AFTER RESPONSE HAS BEEN RECORDED
UPDATED ANSWER
Logic App outlook connector:
result: