10-05-2017 06:40 AM
10-05-2017 06:40 AM
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?
10-05-2017 08:47 AM
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.
11-21-2017 02:27 PM
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?
11-22-2017 02:24 AMSolution
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.
01-06-2018 03:48 AM
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.
01-08-2018 02:10 AM
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 :
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.
01-08-2018 06:10 AM
I see, some competitive products have this feature (Survey Monkey) but in the implementations I've seen you give them a list of the email addresses you want to invite and they automate the process, this isn't something that Microsoft Forms has at this stage.
I can't really think of a way to build it in Office 365 using tools like PowerApps, the issue is that nearly every service requires users to be logged in.
Microsoft invites suggestions for new features for Forms at https://microsoftforms.uservoice.com, if you get enough support they are keen to build what their users are asking for.
01-08-2018 06:12 AM - edited 01-08-2018 06:20 AM
@Steven Collier thank you so much.
The suggestion already exist on Uservoice :)
But I'm gonna up-vote it ;)
04-04-2018 07:59 AM
Hi @Pieter Veenstra,
Your response is helpful, however how do we add the username while creating the sharepoint list item?
04-04-2018 08:51 AM
04-15-2018 07:35 AM - edited 04-15-2018 07:36 AM
Thanks for explaining your suggestion in more detail, Pieter. I do now understand the approach. We haven't tested it yet, but it sounds like a feasible way to meet the requirement. Not verbatim, but the objective may be reached. :)
12-07-2018 08:45 AM
This would be awesome for sending automated emails with a survey response related to a specific transaction allowing to link an order number, ticket number...
I will vote for this feature in user voice as well!
06-25-2019 01:25 PM
I need this exact setup also. Using Twilio for people to subscribe and saving their phone number in a database. I want to send a Link to a Form if they choose to fill out more info.
I need to be able to connect the account that was added in the DB to the Form data without having the user input any ID or phone number (because they'll mistype it)
07-11-2019 07:19 AM
This would be incredible useful. I used this quite a lot with G Forms at my previous employer. It allows me to automatically send out pre-filled but still editable information. For instance, when sending out Inventory acknowledgement forms, it allows me to tell users "This is what we have for you in inventory:" The user can then edit it if necessary and I can compare in spreadsheets and follow up for discrepancies. This level of customization is why G rules this space.