Forum Discussion

René Fritsch's avatar
René Fritsch
Iron Contributor
Oct 05, 2017
Solved

Pre-populate fields in Microsoft Forms via URL parameter?

Is there a way to pre-populate a field on a form in Microsoft Forms using a parameter that is attached to the form's URL? 

 

Idea/scenario behind this: We could send out personalized links to people from whom we'd like to gather some information, e.g. https://[my-form-url]?UserID=27

 

Result: When the receipient opens the link in the browser, the field "UserID" would already be filled with the value 27 without the need to enter the number manually.

 

In SharePoint URL-parameters are quite common for many years, for example for filtering the content that is shown in certain web parts. I was wondering if Microsoft Forms can already handle a similar functionality. 

 

Any ideas/thoughts on this?

  • Sending context-aware survey invitations and capturing the response with a particular context is a feature of Forms Pro, which can be combined with Flow.
    You will find detailed walkthrough articles in Megan Walker blog covering the different steps involved. Here is one of her posts:
    https://meganvwalker.com/send-forms-pro-survey-invites-via-csv-file/

40 Replies

    • Steven Collier's avatar
      Steven Collier
      MVP

      In form settings you can set it to record name, based on their user account, then as Pieter Veenstra mentions you could easily tie up their response with some reference data you have about that individual.

       

       

      • Ludovic Floch's avatar
        Ludovic Floch
        Brass Contributor

        Hi Steven Collier,

         

        Thanks for taking time to answer.

         

        My need is to allow persons who don't belong to my organisation to be identified.

         

        For example, I create a new form and I add a "UserID" field that reference an ID somewhere else in my organization (CRM, registration form, whatever...).

         

        I send a SMS campaign with a link inside it, like the following one :

         

        https://[my-form-url]?UserID=27

         

        Where UserID reference the field name.

         

        When the person click on this link, the GET parameter is automagically injected into the form, right into the UserID field.

        The main objective is to identify the user without asking them to enter manually their ID (mitigating risk of typos, etc...).

         

        I hope you see more precisly my needs.

         

        Kind regards,


  • Hi René Fritsch,

     

    As far as I know that doesn't exist. You could get the user to complete the form and kick off a Flow on completion. Then create a new list item within the flow where you populate all the information that you wanted to prepopulate the Form with.

    • René Fritsch's avatar
      René Fritsch
      Iron Contributor

      Hi Pieter, thanks for taking the time to reply! Not sure if I understand your suggestion correctly. Do you mean that "Flow" is capable of parsing the URL of my form so that it can extract any parameter(s) that I append to it?

      • Pieter Veenstra's avatar
        Pieter Veenstra
        MVP

        Hi René Fritsch,

         

        I was more thinking along the lines of, why tell a user what their name is in a field? Just collect the data that you want to collect from the user and then afterwards in a Flow create SharePoint list items or Database records with the data that you have collected and add the username to this data.

Resources