Announcements
303
Hello everyone,
I need to send an email with options, for example: 'In office', 'Working from home', and 'N/A' to around 200 people and collect each response along with their name, and store it in an excel sheet or SharePoint list. Is this possible? Would it also be possible to track who responded to this email?
Thanks ahead of time!
Is there a way to track email responses when using "send email with options" if you are sending the email to folks outside of your organization? I am trying to create an email chain that connects all of the back and forth communications between 2-3 parties using power automate and Microsoft forms. I began with a form to a particular set of people using a mail merge. Then they would respond via the Microsoft form linked inside the email, power automate would then place the form responses into a SharePoint list - making the form responses visible to internal folks, and then power automate would send another mail merge via "send email with options" to another set of people. I get stuck after this part. I need to know how to gather the email with option responses and then based on their response trigger another action in Power Automate. Thank you.
Hi @JMAFO,
As far as I know, there is no way could set the MS Form daily sent and make it only allowed response once a day.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @JMAFO,
I think @RobElliott is correct, you could use the MS Form to do it.
If you want to track who responded to the Form, as you mentioned, you want to store responses in an excel sheet or SharePoint list, so you could update an Excel that with all recipients. Once one person responds it, update the Row according to the Responder's email.
And before create Flow, the MS Form survey should set to "Only people in my organization can respond":
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@DanyElHoyek "The bad news is that Flow have a limitation of 100 email by day by user." . Not exactly, that's only if you use the Send an email notification (V3) action. Send an Email (V2) can send 900 emails every 60 seconds which should meet most requirements.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
MS Forms Options is a better alternative for your requirement.
You can send an email with options, collect user response and store in SharePoint or excel (recommend SharePoint for that).
The bad news is that Flow have a limitation of 100 email by day by user. you should find a workaround for this design limitation.
Yes forms, is a simple solution.
Power Apps would be good if you had the time to develop a App.
Let me know if you need help with the Flows, if you decide to go down the MS forms path.
—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
