How can I pre-fill information from a Power Automate flow into a SharePoint form?

Question

I would like to pass information from a Power Automate flow into a SharePoint Form, so that the Form opens with fields pre-filled when the flow is run, but the user has the ability to review and edit the form field contents before submitting it as a new item to the SharePoint list.

It appears that it is possible to create pre-filled links in MS Forms; however, I cannot find a similar function for setting pre-filled answers in the Microsoft Lists-powered equivalent. Is it possible to pre-fill fields via URL parameters or similar?

Answer 1

Hi @Steven Schrag ,

Good days. Welcome to Q&A forum!

Unfortunately, out‐of‐the‐box modern SharePoint list forms don’t support URL parameters for pre‐populating field values the way Microsoft Forms does. In other words, you cannot simply add query string parameters to the default NewForm URL and have SharePoint automatically pre-fill those fields. The recommended solution is to use Power Apps.

You can customize your SharePoint list form using Power Apps. In a Power Apps–customized form you can read URL parameters using the Param() function and then set the Default property of each data card to the corresponding parameter value.

For example, if you launch your form with a URL like:

https://<tenant>.sharepoint.com/sites/SiteName/Lists/ListName/NewForm.aspx?Title=PreFilledTitle&CustomField=Value

…then in your Power Apps form you can set the Default property of the Title card to:

If(!IsBlank(Param("Title")), Param("Title"), Parent.Default)

And similarly for any other field.

This method lets your Power Automate flow launch the custom form with URL parameters so that when the user opens it, the fields are already pre-filled (while still remaining editable).

Since Power Apps is not currently supported in the Q&A forum, for more detailed steps, it is recommended that you go to the Power Apps Community to post and discuss to get more targeted support.

Hope this information helps.

Please do let us know if you have any further queries.

Kindly consider accepting the answer if the information provided is helpful. This can assist other community members in resolving similar issues.