Forum Discussion
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...
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
Thank you for responding. Is there a less automated solution without using power automate? Eg comparing those responses received vs the master list of the email circulation
- You could manually compare the spreadsheet of responses in Forms with your spreadsheet of everyone the form was sent to.