Answered

Patch is not updating record

(1) Share

Report

Posted on by BG-15041758-0

Hi,

I'm having an issue with a patch command that updates records in a gallery. It works on the first record, but not working on any other line. below is the code which looks right to me so I'm not sure why it's not working.

Patch(
    'Purification-Buffer-Details',
    BufferGallery.Selected,
   // LookUp('Purification-Buffer-Details', ThisItem.BufferID=Value(TxtID.Text)),
    {BufferName: BuffInput.Text,
    Volume:VolInput.Selected,
    BufferComponent:BuffComInput.Selected,
    Salt:SaltInput.Selected,
    Glycerol:GlycerolInput.Selected,
    EDTA: EDTAInput.Selected,
    TCEP:TCEPInput.Selected,
    Imidazole:ImidInput.Selected,
    Additives:AddInput.Selected
    }
);
Notify("Your record has been updated",NotificationType.Success,2000)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

BCBuizer 22,763 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @BG-15041758-0,

I'm assuming the controls that have the data you wish to save are inside the gallery, coorect?

If so, the formula should be updated to reference exactly the instance of the controls to use, since there is a set for each item in the gallery:

Patch( 'Purification-Buffer-Details', BufferGallery.Selected, { BufferName: BufferGallery.SelectedBuffInput.Text, Volume:BufferGallery.Selected.VolInput.Selected, BufferComponent:BufferGallery.Selected.BuffComInput.Selected, Salt:BufferGallery.Selected.SaltInput.Selected, Glycerol:BufferGallery.Selected.GlycerolInput.Selected, EDTA: BufferGallery.Selected.EDTAInput.Selected, TCEP: BufferGallery.Selected.TCEPInput.Selected, Imidazole:BufferGallery.Selected.ImidInput.Selected, Additives:BufferGallery.Selected.AddInput.Selected } ); Notify("Your record has been updated",NotificationType.Success,2000)

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
Suggested answer

11manish 2,509 on at

Like (0)

Report
Copy link

Link copied!
Try this:

Patch( 'Purification-Buffer-Details', ThisItem, { BufferName: BuffInput.Text, Volume: VolInput.Selected, BufferComponent: BuffComInput.Selected, Salt: SaltInput.Selected, Glycerol: GlycerolInput.Selected, EDTA: EDTAInput.Selected, TCEP: TCEPInput.Selected, Imidazole: ImidInput.Selected, Additives: AddInput.Selected } ); Notify( "Your record has been updated", NotificationType.Success, 2000 )

Was this reply helpful? Yes No
Suggested answer

Valantis 5,742 on at

Like (1)

Report
Copy link

Link copied!

Hi @BG-15041758-0,

where your input controls (BuffInput, VolInput etc.) are located?

If the controls are inside the gallery: use BCBuizer's approach. Reference them via BufferGallery.Selected.ControlName so Power Apps knows which gallery item's controls to read. Without this, all controls resolve to the first item's instance.

If the controls are outside the gallery (e.g. on the same screen but not inside the gallery): use 11manish's ThisItem approach. Replace BufferGallery.Selected with ThisItem as the second Patch argument so it patches the current row being processed.

The reason it only works on the first record is almost certainly that your controls are inside the gallery but you're referencing them without the gallery prefix. Power Apps defaults to the first instance of a named control inside a gallery, which is why record 1 updates correctly and all others don't.

Check where your controls sit in the tree view and apply the matching fix.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No