Unanswered

How can i create a new record by editing a existing record using PowerApps.

(0) Share

Report

Posted on by spanigrahi

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
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

Was this reply helpful? Yes No
Sanshubh 512 on at

Like (0)

Report

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

Was this reply helpful? Yes No
spanigrahi 15 on at

Like (0)

Report

But I have to use more than 50 columns any other easy way

Was this reply helpful? Yes No
spanigrahi 15 on at

Like (0)

Report

But I have to use more than 50 columns any other easy way

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Hi @spanigrahi ,

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

Best Regards,
Dezhi

Was this reply helpful? Yes No
Dai_Xin 41 on at

Like (1)

Report
Hi @spanigrahi ,

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.

Best Regards,
Kris

Was this reply helpful? Yes No