Forum Discussion
Pre-populate fields in Microsoft Forms via URL parameter?
- 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/
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.
