Oct 05 2017
06:40 AM
- last edited on
Aug 06 2023
01:58 PM
by
TechCommunityAP
Oct 05 2017
06:40 AM
- last edited on
Aug 06 2023
01:58 PM
by
TechCommunityAP
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?
Aug 23 2019 02:20 AM
@Bertrand D arbonneauThank you!
Dec 15 2019 11:09 AM
Still waiting for feature as of 12/15/2019....
Jul 13 2020 06:14 AM
Looks like this functionality is achievable now, check the following video -
Sep 24 2020 09:18 AM
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.
Dec 19 2020 03:03 PM
Cognito 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.
Mar 29 2021 04:58 AM
Mar 05 2023 08:51 PM
Apr 26 2023 11:23 PM
@drkmccy 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:
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.
Jul 03 2023 06:56 AM
Dec 07 2023 01:34 PM
May 10 2024 07:36 AM
@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.
May 10 2024 07:56 AM - edited May 10 2024 09:49 AM
May 10 2024 07:56 AM - edited May 10 2024 09:49 AM
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]
May 10 2024 09:24 AM
@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.
May 10 2024 09:47 AM
May 10 2024 11:09 AM