*** NOTE: ALL INFORMATION IS ACCURATE AT DATE OF PUBLISHING ***
DISCLOSURE: THIS POST MAY CONTAIN AFFILIATE LINKS. FULL DETAILS HERE

If you send out Forms Pro surveys to your customers there is always the possibility they forget to respond. They are busy and time slips away so even with good intentions they might not get around to providing you with feedback. So what about sending them a reminder after a few days if they haven’t replied to your original request? Let’s take a look at a Microsoft Flow to achieve this.

First we need to start our Flow with a recurrence trigger. This will run every day at 9am.

Next, we are going to use the Date/Time action of ‘Get past time’. The interval is the number of days you want to go before you send a follow up IF your Forms Pro survey feedback request hasn’t been responded to. The time unit will be set to Day.

Now we use the CDS connector and the List records action to find all of the Forms Pro survey invites that meet our filter query criteria. The first part filters based on the msfp_invitestatus. 647390002 is equal to Sent. Once the survey invite is received to, the status changes to 647390003 to indicate Responded. Now we need to format the Past Date we just retrieved and put it in the format of yyyy-MM-dd.We are then going to compare it with the created date of the survey invites to see if it matches. Finally, we are going to check the Status Reason (statuscode) and only get those that equal 1 which is Open.

You can copy and paste this code in to your Filter Query if needed.

msfp_invitestatus eq 647390002 and Microsoft.Dynamics.CRM.On(PropertyName='createdon',PropertyValue=@{formatDateTime(body('Past_Date'),'yyyy-MM-dd')}) and statuscode eq 1

For each Survey Invite that is retrieved in the List action we are going to format the created date. This is so we can add it in to our notification to our client so they have a little context of which request we are referring to. For this we are going to use the Convert time zone action.

Now we need to figure out the Contact that the survey invite is linked to. For this we need to use the activityparties entity. You can’t find this in the drop down list. Instead scroll to the bottom and click on Enter custom value. YOu can then type in activityparties. Then add in the filter query using the _activityid_value for the Activity id from the List survey invites step. We are also going to filter on the Participation Type of the To Recipient which has a value of 2.

You can copy and paste this code in to your Filter Query if needed.

_activityid_value eq @{items('Apply_To_Each_Survey_Invite')?['activityid']} and participationtypemask eq 2

Now we are going to use the CDS connector again and the Get record action to get the Contact the survey invite was sent to. For this, the item identifier is the Party id from the list activity parties step.

Let’s create our reminder email which can then be sent out to the Contact. The To field will be the Email address from the Get Contact step. Put in whatever subject you wish to use, then fill out the Body of the email. Here we can see the First Name from the Contact, the Converted time to show when the original invite was sent, and the survey invitation url from the original survey invite. This means the link they click on will be the same personalised link you sent them previously.

Here is our completed email received by a customer. You can decide how many times you will do this, although likely one reminder is enough. If they don’t respond after that, let’s just leave them alone 🙂

Want to just watch how to do this? Check out the video below:


Check out the latest post:
Overview Of Satisfaction Metrics in D365 Customer Voice


DISCLOSURE: THIS POST MAY CONTAIN AFFILIATE LINKS. FULL DETAILS HERE
This is just 1 of 254 articles. You can browse through all of them by going to the main blog page, or navigate through different categories to find more content you are interested in. You can also subscribe and get new blog posts emailed to you directly.


15 thoughts on “Send Reminder When Survey Response Not Received

  1. Hi Megan,
    Nice blog, thanks for sharing.
    In our environment, we have noticed Survey Invitation URL is null, any idea why?

    Thanks,
    Mehul

    1. Hi Mehul, is it blank on your most recent survey responses? Originally it was blank on the responses coming through, but that was resolved in a recent release. If it is still blank, I would contact Microsoft with a support ticket to ask them to review.

  2. Hi Megan,
    A co-worker provided a link to your blog – very helpful. I read through this article and it seems a user could do the same kind of reminder flow in Forms as well as Forms Pro. Am I missing something here?

    1. Hi Mike, glad you’ve found it useful! You won’t be able to do the same with regular Forms. The difference is where the data is stored, and that’s in the Common Data Service for Forms Pro. So you can use the records stored in CDS that show the survey invitation hasn’t been responded to yet, and send the reminders. Not sure how you would achieve that with Forms other than doing everything manually. Hope that helps!

  3. Thank you this worked great!

    Question: How do you structure it if you only want the reminder to be sent once? Our users will revolt if they get more than 1 reminder 🙂

    Is it a change to the original trigger? Or an update to the record to indicate a reminder has been sent.

    Your blog is terrific

    1. Hi Kelly, thanks so much! The reminder should only go out once, because the query is finding those that have a created date that equals the same date as X number of days ago, rather than just finding any that haven’t been responded to. So you should find it only goes out once for each of the survey invitations that are outstanding.

  4. Hi Megan, I’m thinking about using your reminder method, but have one issue with it.
    This way it seems not possible to add an unsubscribe link with the mail. An unsubscribe option must be added, maybe even by law.
    The Forms Pro connector of Power Automate doesn’t have an action like “create unsubscribe link” (which must not be that hard to develop I guess), nor is this link saved with the original invitation.
    Do you have a workaround for this?
    Kind regards,
    Maurits

    1. Hi Maurits, this is very true, there is no way to get an unsubscribe link for Forms Pro… however, you could always add an unsubscribe link to the reminder emails that you send out. That way they are unsubscribing to your emails and should mean they won’t get anything further from you. It’s not ideal, but it’s the only thing I can think of that might help.

    2. Thanks for the prompt reply, Megan.

      Are you close with the MS development team so maybe able to request for a “Create unsubscribe link” action in Power Automate? 🙂

      Kind regards,
      Maurits

  5. HAHA, anyway, I’ve solved it in another way.
    Like I used to do with the Voice of the Customer I created a seperate Unsubscribe survey.
    This works like a charm, as I can now create the invitation link for the CSAT survey and one for the Unsubscribe survey.
    It’s just that I cannot use the email templates of Forms Pro in that case, but I win a lot with it.
    I can handle unsubscriptions in a much better way then the Forms Pro way.
    Happy with the results!

    Kind regards,
    Maurits

Leave a Reply

Your email address will not be published. Required fields are marked *