Unanswered

Update collection in gallery and datasource

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm having issues with updating records in a gallery to the data source. I am using this video (Create and update a collection in a canvas app (contains video) - Power Apps | Microsoft Learn) as a guide but when I try to update, it creates a new record instead of updating the existing record. How do I go about this?

Many thanks!

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous - what is the current code you're using to Patch the Gallery items to your data source?

Below is a simple example for SharePoint:

Patch ( 'Your Data Source', ForAll( Gallery1.AllItems, { ID: ID, field_1: TextInput1.Text } ) )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I am using patch to get items from user inputs and send over via Excel. The code I'm using is:
Patch(
collection1,
ThisItem,
{
BOLNo: BOLNoinput.Text,
ArrivalTime: ArrivalTimeinput.Text,
BranchNo: BranchNodropdown.Selected.Value,
DateReceived: DateReceivedinput.SelectedDate,
DeliveryQuality: DeliveryQualitydropdown.Selected.Value,
DepartureTime: DepartureTimeinput.Text,
PointofContact: PointofContactinput.Text,
NotificationofLateDeliveryvia: Notifoflatedropdown.Selected.Value,
'MasterLoad ': MasterLoadinput.Text,
IssueCode: IssueCodedropdown.Selected.Value,
ProductNumberOrdered: ProductOrderedinput.Text,
ProductNumberShipped: ProductShippedinput.Text,
QtyOrdered: QtyOrderedinput.Text,
QtyReceived: QtyReceivedinput.Text,
QtyShipped: QtyShippedinput.Text,
ServiceFailure: Switch(
Checkbox2.Value,
true,
"Yes",
"No"
),
CustomerFailure: Switch(
Checkbox1.Value,
true,
"Yes",
"No"
),
XFRNo: XFRNoinput.Text,
Comments: Commentsinput.Text
}
);
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous whether you are patching a Collection or patching the Data Source, if the Patch expression cannot locate a matching record to update, a new item is created by default.

I assume you're also patching collection1 back to your data source?