Patching all input edits to all gallery items (Dataverse table) with button outside the gallery

(0) Share

Report

Posted on by Cgangweg01

727 Super User 2025 Season 2

Hello!

Fairly new to Power Apps and I'm sure the solution involves Patching, maybe a For All and perhaps a temporary collection but I can't seem to put this all together after watching several videos and reading many posts here and elsewhere.

I want a button outside the gallery to save edits made in any input column of the gallery on any row. See screen shot of app.

I am able to Save/patch individual row edits with the following patch formula.

Appreciate any guidance or reference.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Akash1ve 112 on at

Like (0)

Report

Considering your gallery name as Gallery1 . Can you try something like below?

ForAll(
Gallery1.AllItems,
Patch(
'Table1S',
LookUp('Table1S', ID = ThisItem.ID),
{
'Par Level': Value(txtParLevelEdit.Text),
'OnH1': txtOnHandAmt1Edit.Text,
'QTY1': txtQty1Edit.Text,
'OnH2': txtOnHandAmt2Edit.Text,
'QTY2': txtQty2Edit.Text,
'OnH3': txtOnHandAmt3Edit.Text,
'QTY3': txtQty3Edit.Text,
'OnH4': txtOnHandAmt4Edit.Text,
'QTY4': txtQty4Edit.Text
}
)
);
Notify("saved!", NotificationType.Success,2000);

Was this reply helpful? Yes No
Cgangweg01 727 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Akash1ve

Thanks for the quick reply.

I used your suggestion, and it is not recognizing ID = ThisItem.ID.

I think ID may work with SharePoint lists. My table is in Dataverse.

Any idea how to adjust?

Was this reply helpful? Yes No
Cgangweg01 727 Super User 2025 Season 2 on at

Like (0)

Report

Hi again @Akash1ve

I got the formula to save with this change ... but it didn't update the row that I edited and instead updated the first row in the table by clearing the values.

Strange result.

Any suggestion now?

Was this reply helpful? Yes No
Verified answer

Cgangweg01 727 Super User 2025 Season 2 on at

Like (0)

Report

Hi!

Not sure why this was so hard to find.

This worked like a charm ...

Was this reply helpful? Yes No