Patch Collection in a Gallery via Text Input

(1) Share

Report

Posted on by alexaso

Hello Supporters,

I have a strange behavior in patching a collection.

OnChange / OnSelect Formula should patching the textinput to 'ThisItem'. Instead the 1st Row is updated.

Any thoughts on this?

Old Thread without solution:

Patch gallery only works on first item - Power Platform Community (lithium.com)

Thanks,

Alex

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

jthewissen 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

The patch function probably sees two possible records that can be updated and because of this it will default to the first record.
You probably need to replace ThisItem in the patch with the following:

first(filter(ColEbeneW1Antworten, ID = ThisItem.ID)) < This will select the correct record in the collection by using a unique identifier, like ID.

Hope this helps.

Kind Regards,

Jeannot Thewissen

Was this reply helpful? Yes No
alexaso 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Still not working. I even entered the explicit ID

Patch(colEbeneW1Antworten;First(Filter(colEbeneW1Antworten; ID = 1)) ;{Grund: W1Antwort1_9.Text });;

Was this reply helpful? Yes No
Suggested answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

Try LookUp instead:
Patch(colEbeneW1Antworten;LookUp(colEbeneW1Antworten; ID = 1);{Grund: W1Antwort1_9.Text });;

Please click Does this answer your question 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 a Like.

Thanks,

ANB

Was this reply helpful? Yes No
Verified answer

alexaso 39 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for you support! It was a bug with the textinput field. I have created a new one and now the patch with ThisItem works

Patch(colEbeneW1Antworten;ThisItem;{Grund: W1Antwort1_9.Text });;Patch(Warum5xCollection;Problemanalyse.Selected;{Status:"Update"})

Was this reply helpful? Yes No