Announcements
Hi
By using the power app when we are entering the filed details and save it it will go to SharePoint and create a new record but now I want for an existing record if I click on edit and do some changes it should create a new line item instead of updating that existing record.
Hi @spanigrahi ,
You can try to use Patch() to add new records to your data source.
Patch(data soure,Defaults(data soure),{column1:value,column2:value2....})
Please check the link below:
Patch function in Power Apps (contains video) - Power Platform | Microsoft Learn
Best Regards,
Dezhi
Use the patch function to achieve that. Patch function is used to save data and update data you just open edit form and use patch function to create new entry.
Here Link for it:https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch
But I have to use more than 50 columns any other easy way
You can save the records you want to add to a collection, and then use forAll.
ForAll(collention,Patch(data soure,Defaults(data soure),ThisRecord))
Do you use the Edit form to create a new record or edit existing record back to your Sharepoint?
If you use Edit form to create new record back to your sp list, you could consider set the OnSelect property of the "Submit" button to following formula:
Patch( 'Your SP List', // replace it with your SP list name Defaults('Your SP List'), // replace it with your SP list name EditForm1.Updates // EditForm1 means the Edit form name in your app )
Hope above solution could solve your problem.
Kris
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
