Forum Discussion
Populating data from Sharepoint list back to a form.
I have a data set of monthly performance information in a sharepoint list. One row per month. Users add to this data via a simple ms form. I would like to be able to offer users the ability to update prior data submissions. Ideally a user would use an ms form, and upon selecting a month with existing data the from would populate with the current data for that month, but allow the user to edit as needed. Submitting the data would cause the records to be updated to the new values. Is this or similar possible, and if so how would you achieve it?
The dataset is the input to a PowerBI dashboard.
Thanks in advance
The dataset is the input to a PowerBI dashboard.
Thanks in advance
5 Replies
evigors it's not possible to pre-populate data from SharePoint (or anywhere else) into a form. For this sort of scenario you would need to build a form in Power Apps with the Sharepoint list as a data source.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)Oh no. This is exactly what I needed to do. Any update 4.5 years later?
No there's no update; the improvements to Forms has mainly been cosmetic. Power Apps is still the only way to have a form pre-populated.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Microsoft Power Platform WSP Global (and classic 1967 Morris Traveller driver)
- Booooo. This is exactly what I want to do too
- I want to do the same thing. Are there any REALLY good templates/examples from power apps that behave like this and would be a good starting point? I'm willing to dive into power apps but a life jacket would be nice for my first swim.
