Forum Discussion

johnm1955's avatar
johnm1955
Copper Contributor
Oct 25, 2022

tracking form respondents

I am running a non-profit / charity group of about 30 to 40 members. I do not have a business or school Microsoft account or SharePoint.  I have developed forms that are sent to each member but woul...
microsoft forms
RobElliott's avatar
RobElliott
Silver Contributor
Oct 25, 2022

johnm1955 the only way to do this would by building a flow in Power Automate that takes the responder details from each submission and checks a SharePoint list of people the form has been sent to and adds the date the response has been submitted to a column inh the list. Then you'd need a flow to run when you want to send the reminder email that has a filter query that only brings back tho9se where the submissi9on date is empty and send the reminder email to only those people. Not difficult but totally not possible with just Forms on its own.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

chriscrain's avatar
chriscrain
Copper Contributor
Dec 06, 2023

RobElliott 

I have been trying to work on something like this where when a form is submitted the flow finds their email on a sharepoint list and marks yes on the "has responded?" column. What you be able to provide more detailed instructions on this?

Resources