Save data in same rows powerapps/sharepoint

Question

Is it possible to save data(e.g sum,update) in same “row” SharePoint list, every time when we “submitform” in power apps? Currently when I fill my form through power apps and save it, In SP it creates “new row” for every form submits.

Data source- sharepointlist

Answer 1

Hi @PAWAN CHETTRI ,

There are three types of FormMode in Power Apps:

If you choose "Edit" mode, it will update the record to data source.So for your issue, please check whether DefaultMode is set to “Edit”:
You can click your Form in the Tree view -> Select “DefaultMode” from the drop-down list on the top -> check if the mode is “Edit” :

If it is not, change it to “Edit” and retry.
Besides,as your issue is more related to Power Apps, I suggest you to go to Power Apps Community for better help.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Yes !

You will have to use the patch function with the look up function in it.

Sample Command :

 Patch('SPLIST', LookUp( 'SPOLIST', OrderId = OrderId.Text ),   {OrderName: "val1"   } 	)  

As per the above, it tries to update an item in the SPList which matches a specific OrderId.

OrderId = OrderId.Text  

This is the line which identifies a specific row in the sharepoint that will have to be updated.