Hello, everyone! I kindly need your help in designing a flow structure for the following scenario:
I am collecting responses on MS Forms by sending out an email that contains the link to the form. The email is sent to an AD group that has more than 400 members in it. I would like to develop a flow that is manually triggered after a week or so and sends a follow up email to the people who have NOT submitted a response on the form. Is there any way in the Flow to exclude the list of people that have submitted a response and include the ones that have not in my follow up email?
Here is a screengrab of the option i was referring to.
@P1c0Pugh unlike a bulk mail program, DotDigital for example, Forms does not record who has NOT responded, it has no feature to do that, it just records the responses received. So unless you want to do a manual cross-check - which would be a headache with 400 recipients - you need to have the email address of form recipients in a SharePoint list together with a column for the date they responded. When each form response is submitted a flow takes their email address and updates the relevant item in the recipients list with the current date. Then, as @Hardesh15 said, in a separate flow you have a recurrence schedule trigger set to run after 7 days to get all the items where the date responded column has a zero length and send a reminder to each one.
Rob
Los Gallardos
i thought you could do this from the Form itself. When you send it to the list of users, the form records who has responded and then you can chase up the ones who haven't. I can't seem to find the option now, but it may be worth searching from the Forms point of view rather than Flow.
@Hardesh15 , thank you for the reply! Could you please elaborate the part that compares the users? Do you mean I should compare submitted users’ emails against the whole list? Thank you for your time!
@aaliyev First you need to store form responses along with responder emails. After that you can design your scheduled flow. In scheduled flow you will compare your users using get items with filter and then use length(). In this way if your length() is zero you can send email otherwise do nothing in No block of condition.
Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.