Forum Discussion
tracking form respondents
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
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?
- 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.
