Patching several registers starting from a Gallery

(0) Share

Report

Posted on by Rushtrinity

All right. We are trying to patch several registers to update the inventory with a single button. So far, no good.

Have tried something like this:

ForAll(
Gallery1_5.AllItems;
Patch(
'SP_List';
LookUp('SP_List'; Gallery1_5.Selected.Título = Título);
{
Quantidade:Value(Gallery1_5.Selected.Quantidade) - TextInput2.Text
}
)
)

/*Patch('SP_List';
ForAll(
Gallery1_5.AllItems;
{
Quantidade:Value(Gallery1_5.Selected.Quantidade) - TextInput2.Text
}
)
)*/

Is ForAll the best approach? Quantidade is the quantity. Don't mind the semicolon, different language.

captura 1.png

captura 2.png

Thank you very much

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Rushtrinity .

ForAll() is the correct approach, but you need to refer to each item in the gallery

Patch( 'SP_List'; ForAll( Gallery1_5.AllItems As _Data; With( { _ID: LookUp( 'SP_List'; Título = _Data.Título ).ID }; { ID: _ID; Quantidade:Value(_Data.Quantidade) - Value(_Data.TextInput2.Text) } ) ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps
Rushtrinity 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Man, it seems it worked, but I can't say I understand the rationality behind the solution.😂 Would you mind to explain to me how does it work specially regarding the As _Data, the _ID and the ).ID?

Also, what
ID: _ID;
Quantidade:Value(_Data.Quantidade) - Value(_Data.TextInput2.Text)

is comparing?

Edit: Oh, I think I got the logic.

TYVM
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Rushtrinity ,

The As function is a disambiguation operator and useful to identify the source and target of ForAll patches separately. He second bit is finding the ID of the target record in the With() statement and then using it to specify the record to Patch.