Populating data from Sharepoint list back to a form.

%3CLINGO-SUB%20id%3D%22lingo-sub-2704636%22%20slang%3D%22en-US%22%3EPopulating%20data%20from%20Sharepoint%20list%20back%20to%20a%20form.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2704636%22%20slang%3D%22en-US%22%3EI%20have%20a%20data%20set%20of%20monthly%20performance%20information%20in%20a%20sharepoint%20list.%20One%20row%20per%20month.%20Users%20add%20to%20this%20data%20via%20a%20simple%20ms%20form.%20I%20would%20like%20to%20be%20able%20to%20offer%20users%20the%20ability%20to%20update%20prior%20data%20submissions.%20Ideally%20a%20user%20would%20use%20an%20ms%20form%2C%20and%20upon%20selecting%20a%20month%20with%20existing%20data%20the%20from%20would%20populate%20with%20the%20current%20data%20for%20that%20month%2C%20but%20allow%20the%20user%20to%20edit%20as%20needed.%20Submitting%20the%20data%20would%20cause%20the%20records%20to%20be%20updated%20to%20the%20new%20values.%20Is%20this%20or%20similar%20possible%2C%20and%20if%20so%20how%20would%20you%20achieve%20it%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20dataset%20is%20the%20input%20to%20a%20PowerBI%20dashboard.%3CBR%20%2F%3EThanks%20in%20advance%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2704636%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor
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
1 Reply

@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)