I have a very simple flow that uses Send email with options, and adds the user response to an Excel table. I'm able to bring in their response and other metadata such as date, but when I try to bring in UserID or UserEmailAddress to document whose response it is, nothing gets written to the field. Looking at the raw inputs I see it is "null". Any ideas why it isn't working?
Thanks!
Solved! Go to Solution.
Hi @cspidex
Thank you for posting.
According to your description, you would like to collect choices from user using ‘send email with option’. But currently can’t extract responder’s address as expected. If any misunderstanding, please kindly let me know.
Actually, this is caused by the limitation of ‘send email with options’. If we use this action, we can only get response content only. But for other information like sender address, replied time, they’re all not supported from returned result.
https://docs.microsoft.com/en-us/connectors/office365/#send-email-with-options
Thus, to get response as well as the related submitters’ information, I recommend you can use ‘Approval’ function here.
The flow may look like as below:
Once tested, I’m able to get detailed information listed in excel:
Hope the content above may help you.
Best regards,
Anna
Hi @cspidex
Thank you for posting.
According to your description, you would like to collect choices from user using ‘send email with option’. But currently can’t extract responder’s address as expected. If any misunderstanding, please kindly let me know.
Actually, this is caused by the limitation of ‘send email with options’. If we use this action, we can only get response content only. But for other information like sender address, replied time, they’re all not supported from returned result.
https://docs.microsoft.com/en-us/connectors/office365/#send-email-with-options
Thus, to get response as well as the related submitters’ information, I recommend you can use ‘Approval’ function here.
The flow may look like as below:
Once tested, I’m able to get detailed information listed in excel:
Hope the content above may help you.
Best regards,
Anna
User | Count |
---|---|
90 | |
41 | |
22 | |
20 | |
16 |
User | Count |
---|---|
134 | |
54 | |
47 | |
36 | |
25 |