cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vish_p
Helper V
Helper V

Temporary storing of user input and final submit

I have linked a sharepoint list to my powerapp as a form and user will be submiting the form using the input data.

Now the requirement is that they would like to have a temporary storage like a local collection wherein they can keep on adding datas and finally after verifying all the data details they'll be submitting to the form (i.e. sharepoint list) and all these datas should be stored as seperate rows in sharepoint list ..any way to acheive that ?

2 REPLIES 2
v-monli-msft
Community Support
Community Support

Hi @vish_p,

 

Generally, I think what you want to achieve is bulk updating records to SharePoint list at once. In your scenario, your Source(Collection) and Destination(SP list) could have the same column names, you can use a simple Patch statement. Hence you can use the below formula to update the source at once with all the changes.

Patch(ListName , CollectionName)

 

You can create the collection with a formula similar to below formula to make the Patch work properly:

Collect(CollectionName,{Title:DataCardValue1.Text,DateTime:DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0),Person:DataCardValue2.Selected})

 

In the EditForm control, you can unlock the data cards, then copy and paste the formula inside each data card's Update property. Then the formula could be easily created with:

Collect(CollectionName,{ColumnNames:FormulaJustCopiedHere,......})

Make sure ColumnNames are exactly the same as SharePoint list column names.

 

Regards,

Mona

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Excuse me,since i am new to collection concept i need a bit more clarification on this :

Consider i am linking a sharepoint list as form in my app,now user will be able to fill in details on that columns which are autofetched from sharepoint list ,now after filling in the data when user is going to click on a button it should take all the currently entered data into a collection in background and again if user wish to add data he/she can do the same in that and finally they can exit.
Now when the approver is logging in to my app (using o365 mail id) he should be able to view all these datas which is lying in collection and should be able to export selected rows from that to excel (may be using flow) and then when he clicks on submit all the rows from collection should be bulk uploaded to my linked sharepoint list.

please help me for this requirement 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,901)