Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Follow-up email based on MS Forms

(0) ShareShare
ReportReport
Posted on by 5

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?

Categories:
  • P1c0Pugh Profile Picture
    P1c0Pugh 10 on at
    Re: Follow-up email based on MS Forms

    P1c0Pugh_0-1675186433693.png

    Here is a screengrab of the option i was referring to.

    P1c0Pugh_1-1675186488515.png

     

  • RobElliott Profile Picture
    RobElliott 10,012 on at
    Re: Follow-up email based on MS Forms

    @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

  • P1c0Pugh Profile Picture
    P1c0Pugh 10 on at
    Re: Follow-up email based on MS Forms

    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.

  • aaliyev Profile Picture
    aaliyev 5 on at
    Re: Follow-up email based on MS Forms

    @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!

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: Follow-up email based on MS Forms

    @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.

    @Hardesh /Gopenly.in

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard