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:

Using Apps Using Formulas

All responses (4)

Answers (1)

Verified answer

alexaso 39 on at

Like (0)

Report

Patch Collection in a Gallery via Text Input

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"})
Suggested answer

ANB 7,075 Super User 2025 Season 1 on at

Like (0)

Report
Patch Collection in a Gallery via Text Input

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
alexaso 39 on at

Like (0)

Report

Patch Collection in a Gallery via Text Input

Still not working. I even entered the explicit ID

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

jthewissen 26 on at

Like (0)

Report

Patch Collection in a Gallery via Text Input

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