Power Platform Community Forum Thread Details

I have a collection that looks like this:

Where OT is the Key of the table.

Im trying to patch inside "data" and for that im trying to use this:

Patch(LookUp(colOTOrders;OT=ThisItem.OT).data;colFieldsEdited);;

Where colFieldsEdited is a collection that contains the columns in "data" that needs an update.

This is my collection "data"

and this is my collection "colFieldsEdited"

My issue here is that this works sometimes, and sometimes it gives me an error "the data source is not valid".

Is there any other way to takle this or avoid the error?

Categories:

Building Power Apps

Hi @Anonymous

the Patch() function typically requires three elements, a datasource or collection, the record being patched and the field in the record being patched inside curly braces with a colon between the fieldname and the new data to overwrite the old data in that field. Assuming that the Patch is executed from the OnSelect property of an icon or button from inside the gallery, it should look something like this:

Patch(collectionname,ThisItem,{field:data})

replacing the collectionname with your collection or data source, ThisItem refers to the row in the gallery, and data can be from a control in the gallery row or a lookup to another record if you are patching the datasource of the gallery. To patch another datasource, replace ThisItem with a Lookup() to the row in the second datasource, typically something like Lookup(datasource2,ID=ThisItem.ID).