Microsoft Forms connector not returning questions

Microsoft Forms is great to create a survey, but what if you want to use Power Automate to process responses? Should you upgrade to Forms Pro?

Microsoft Forms

If you have been using Microsoft Forms for a while then you will know how to create a new survey.

Microsoft Forms

Microsoft Forms Pro/Dynamics 365 Customer Voice

When you use Forms Pro you might have noticed the recent rename of the product to Dynamics 365 Customer Voice.

Microsoft Forms and Forms Pro in Power Automate Microsoft Office 365, Microsoft Forms, Microsoft Power Automate image 62

Notice that in Forms Pro you have multiple environments that you can select. So similar to the other Power Platform products you can separate your forms by environment.

Forms in Power Automate

In Power Automate there are two connectors for Forms. One is for Forms Pro and one is for Forms.

Microsoft Forms and Forms Pro in Power Automate Microsoft Office 365, Microsoft Forms, Microsoft Power Automate image 63

The forms connector can trigger a flow when a new response is submitted by someone

Microsoft Forms and Forms Pro in Power Automate Microsoft Office 365, Microsoft Forms, Microsoft Power Automate image 65

Once you have a response you can get the details of the response.

Microsoft Forms and Forms Pro in Power Automate Microsoft Office 365, Microsoft Forms, Microsoft Power Automate image 66

These actions you can use for both Forms and Forms Pro.

For Forms Pro you have a few more specific actions.

Microsoft Forms and Forms Pro in Power Automate Microsoft Office 365, Microsoft Forms, Microsoft Power Automate image 64

That’s enough of an introduction to Forms.

So you are unfortunate enough that your organisation has Forms rather than Forms Pro and you have been asked to collect data from responses.

Now it is important to know what you can and can’t do within Power Automate and what the limitations are of Forms.

Get Response Details

The Get Response Details is easy to configure and for both forms and Forms Pro you will get the response details.

Microsoft Forms and Forms Pro in Power Automate Microsoft Office 365, Microsoft Forms, Microsoft Power Automate image

When you run a flow you will get for each question and answer.

Microsoft Forms and Forms Pro in Power Automate Microsoft Office 365, Microsoft Forms, Microsoft Power Automate image 1

And further down the action you will find a second representation of each question and answer:

Microsoft Forms and Forms Pro in Power Automate Microsoft Office 365, Microsoft Forms, Microsoft Power Automate image 2

In my case I wanted to create a flow that can process any Form without me having to adjust the flow too much.

The two options available both now don’t really work.

  1. Name of questions with answers
  2. Guids with answers

For each of my forms the name of the questions will be different. So referring to those names means that I’m in trouble when I want to reuse my flow for a different form.

The Guids will also be different for each form. What to do?

If you have Microsoft Forms Pro then you are in luck! You can now connect into the Common Data Service to collect the questions from the Guids for each question using the List records action.

Microsoft Forms and Forms Pro in Power Automate Microsoft Office 365, Microsoft Forms, Microsoft Power Automate image 3

Without any further query specified you will get the details of all questions.

[
  {
    "@odata.type": "#Microsoft.Dynamics.CRM.msfp_question",
...
    "msfp_questionchoices": "\"Option 1\",\"Option 2\"",
...
    "msfp_questiontext": "Test Pro Form",
    "msfp_name": "Test Pro Form",
...
    "msfp_sourcequestionidentifier": "rc15c39fa78a648c39a009fc547ede77b",
...
  },
...
]

So now we can use the GUID to query the Customer Voice survey question entity and get our questions.

If you don’t have Forms Pro you will have to do some flow magic to remove the ugly number so that you can collect the data only and strip off the Guids.

Other interesting Forms blogs

https://meganvwalker.com/microsoft-forms-pro/

Avatar for Pieter Veenstra

By Pieter Veenstra

Business Applications Microsoft MVP working as a Principal Architect at HybrIT Services Ltd. You can contact me using contact@sharepains.com

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from SharePains by Microsoft MVP Pieter Veenstra

Subscribe now to keep reading and get access to the full archive.

Continue Reading

%d bloggers like this: