Duplicate Problem While Patching my collection

[Aleksey24]

Hi everyone.

I have i problem patching my collection, in a nutshell, if i try to change any data of my gallery more than once, it duplicates in my collection. The collection is intended to NEVER add new rows, but it does while duplicating the new records, thus not updating the old ones. I have tried to use diferent ways to update my collection, but i have not ended up with the right one. This is a picture of the situation: 

[WarrenBelz · Accepted solution]

Hi @Aleksey24 ,

If I can assume the ID is already there.

Patch(
   coltaskupdate,
   {ID: ThisItem.ID},
   { . . . . 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Aleksey24]

Thank you so much for your answer, though i have one more question, it is related with the calculus that i have to do with the data that the collection changes in my data source (One drive Excel Table). When i do a calculus, for example "=Table$A$1+1" with the numbers in the one drive Excel Table, the cell that contains the "=Table$A$1+1" appear blank until i stimulate the Excel Cell. Do i give up trying?

[WarrenBelz]

Hi @Aleksey24 ,

When you use Excel as a data source, it is no longer a spreadsheet with Column/Row references, but a Data Table (formatted as such) with the first row containing the field names (the columns are then the fields) and all rows after that containing the records. $A$1 means nothing to Power Apps.