Patch changes is adding new items

(0) Share

Report

Posted on by lidor_dayan

192

Hi all,

I have Editable Grid in gallery and I'm trying to patch the changes to the datasource (SP List), when I'm clicking on save it is adding new items to the list with the changes instead of updating the item.

Edit/save Icon Onselect:

If(vareditSOC,Patch('ListName',colGridDataSOC));Select(BtnLoadDataSOC); Set(vareditSOC,!vareditSOC)

Datacards Onchange:

Select(Parent)

Gallery Onselect:

Patch(
colGridDataSOC,
ThisItem,
{
Title: Title.Text,
'Customer Name': CustomerName.Text,
'Project ID': ProjectID.Selected,
'Service Name': ServiceName.Selected,
'Hours Spent': Value(HoursSpent.Text),
'Request Date': RequestDate.SelectedDate,
'Approval Date': ApprovalDate.SelectedDate,
'Execution Date': ExecutionDate.SelectedDate,
Comments: commentsdata.Text
}
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WiZey 3,023 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @lidor_dayan ,

To edit multiple records with "Patch()", you need to provide three parameters:

1. The datasource, of course

2. A table containing the records to update

3. A table containing the updates to apply

Both table must contain the same records in the same order, otherwise you may encounter a few issues.

Patch( datasource, Sort( ShowColumns( Filter( datasource, ID in colGridDataSOC ), ID ), ID ), Sort(colGridDataSOC, ID) )

Hope this was helpful to you.

Was this reply helpful? Yes No
lidor_dayan 192 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WiZey, I have delegation warning in the filter there is other way to do it?

Was this reply helpful? Yes No