Loop and update all Records in a gallery

(0) Share

Report

Posted on by yabela

Hi all,

I am looking for a way how to update all records in a Gallery when the user updates the values. Scenario is as follows;

My gallery named InvoiceLinesGallery with Data Source Table Invoice Lines is as follows;

I would like to save the values the user changes example if user changes descriptions of one or more lines, the new values are saved per record. By using ForAll to loop the gallery and Patch to update all changed records, how can I lookup each record in the Invoice Lines Table and patch (update) it? This is what I have come up with so far;

ForAll(InvoiceLinesGallery.AllItems, Patch('Invoice Lines',LookUp('Invoice Lines', 'Invoice Line' = *reference record ID of current gallery item being looped*), {Description: [@LinesDescriptionTextBox].Text}, {UnitPrice: Value([@LinesUnitPriceTextBox].Text)}, {Quantity: Value([@LinesQtyTextBox].Text)}, {GLAccount:[@LinesGLAccountDropdown].Selected}));

where 'Invoice Line' is the record's GUID identifier column.

Also, should the textboxes be referenced with the '@' i.e. [@LinesGLAccountDropdown]?

Thanks in advance!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @yabela ,

You can try below code if it helps. Please update according to your requirement.

ForAll(InvoiceLinesGallery.AllItems, UpdateIf('Invoice Lines',ID = ThisRecord.ID*reference record ID of current gallery item being looped*, {Description: ThisRecord.LinesDescriptionTextBox.Text, UnitPrice: Value(ThisRecord.LinesUnitPriceTextBox.Text), Quantity: Value(ThisRecord.LinesQtyTextBox.Text), GLAccount:ThisRecord.LinesGLAccountDropdown.Selected.xxxx } ) );

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.
yabela 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PriyankaGeethik ,

Thanks for your input 🙂
When I update the formula as per your instructions, I'm getting an error saying The requested operation is invalid. Server Response: Invoice Lines failed: The right side of the "Equal" operator must be a constant value

This is my formula:

ForAll(InvoiceLinesGallery.AllItems, Patch('Invoice Lines',LookUp('Invoice Lines', 'Invoice Line' = ThisRecord.'Invoice Line'), {Description: [@LinesDescriptionTextBox].Text}, {UnitPrice: Value([@LinesUnitPriceTextBox].Text)}, {Quantity: Value([@LinesQtyTextBox].Text)}, {GLAccount:[@LinesGLAccountDropdown].Selected}));

where 'Invoice Line' is the record's GUID identifier column.

What is wrong in this case?

Thanks!
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @yabela ,
In the formula you are trying to update the Invoice Line with the same records data ? If you want the same data to be added again no need to updating that column.

Try below code. Only update the xxxx and keep rest same.

ForAll(InvoiceLinesGallery.AllItems, UpdateIf('Invoice Lines',ID = ThisRecord.ID, {Description: ThisRecord.LinesDescriptionTextBox.Text, UnitPrice: Value(ThisRecord.LinesUnitPriceTextBox.Text), Quantity: Value(ThisRecord.LinesQtyTextBox.Text), GLAccount:ThisRecord.LinesGLAccountDropdown.Selected.xxxx } ) );

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.