For all items in gallery

(0) Share

Report

Posted on by SamSellars

I have a powerapps inventory management that looks like this

when the button is clicked I want all the values in the boxes to update a list that is connected to the PowerApps.

This is the code I have but It says there is a error with all of it. What have I done wrong?

ForAll(Gallery3.AllItems,
Patch(
'Merch Inventory'
First(
Filter(
'Merch Inventory',
Title = ThisItem.Title
)
),
{Quantity: ThisItem.Quantity - Amount}
));

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
ForAll(Gallery3.AllItems, Patch('Merch Inventory',LookUp('Merch Inventory',Title = ThisItem.Title), {Quantity: ThisItem.Quantity - Amount}));
Give this a go and please share a screenshot with underlined error if you still get an error

Was this reply helpful? Yes No
SamSellars 72 on at

Like
a
(0)

Report
Copy link

Link copied!

@Manan-Malhotra I get this error now

Was this reply helpful? Yes No
Verified answer

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

ThisItem wont work outside of gallery,
Create a label inside gallery and use ThisITem.Title in it.
Then in the code provided by me replace the ThisITem.Title with that Labelname.Text

Do same with Thisitem.quantity

Please Accept as Solution if it solves your question Or just give it a Thumbs Up if it is helpful because this can help others.
LinkedIn: https://www.linkedin.com/in/manan-malhotra-vfx/
Want to support me! Buy me a Cup of Coffee?

Was this reply helpful? Yes No
SamSellars 72 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks that worked

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@SamSellars

Just as an FYI...your ForAll is being used backwards!

You are trying to use it like a ForLoop in some development language - which PowerApps is not. ForAll is a function that returns a table of records based on your iteration table and record schema.

It is more efficient to use the function as intended and will provide better performance.

Patch('Merch Inventory', ForAll(Gallery3.AllItems, {ID: ID, Quantity: Quantity - Amount } ) )

You will find the above to be highly performant as opposed to what you are trying.

Also, since your Gallery already has the ID of the record to update, you don't need to "filter" the list over and over, just provide the ID for the record from the Gallery - patch will know what to do with it.

I hope this is helpful for you.

Was this reply helpful? Yes No