Unanswered

ForAll gallery items will get the last gallery item values

(0) Share

Report

Posted on by johnjohn123

3,506

I have this gallery which contain items that were already created inside SharePoint, and i want to loop through them and update the items, when clicking on the Submit button:-

I tried the below formula inside the submit button, but the issue is that all the items will get the last gallery's item values, so in the above example all items will have Quantity = 300 and Quantity Each Network = 500, and so on:-

Patch('Printing Orders Details',
 ForAll(PrintOrderDetailsGallery.AllItems,
 { ID: ID,
 Quantity: Value(PrintOrderQuantity.Text),
 'Quantity Each Artwork':PrintOrderQuantityForEachartwork.Text,
 'Network ID':PrintOrderNetworkComboBox.Selected.ID
 }
 )
)

and advice?

Categories:

Building Power Apps

I have the same question (0)

All responses (28)

Answers (0)

ANB 7,250 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @johnjohn123 , Check if this can help you
ForAll(PrintOrderDetailsGallery.AllItems As var, Patch('Printing Orders Details', Lookup('Printing Orders Details', ID = var.ID), { ID: var.ID, Quantity: var.Quantity, 'Quantity Each Artwork':var.'Quantity Each Artwork', 'Network ID':var.'Network ID' } ) )
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@ANB thanks for the reply, but i got error, that the ForAll contain invalid arguments

Was this reply helpful? Yes No
ANB 7,250 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Does ID is OOTB ID column from SP list? If yes then you donot have to use again for Patch.
ForAll(PrintOrderDetailsGallery.AllItems As var, Patch('Printing Orders Details', Lookup('Printing Orders Details', ID = var.ID), { Quantity: var.Quantity, 'Quantity Each Artwork':var.'Quantity Each Artwork', 'Network ID':var.'Network ID' } ) )
If this does not work, then please help with screenshot of error message.
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@ANB your updated formula looks exactly as the previous formula, here is a screen shot of the error:-

and yes the ID is the built-in field inside sharepoint lists

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@ANB also the PrintOrderDetailsGallery.AllItems will get the properties values as they are stored inside sharepoint and not the values i entered inside the gallery (modified values)

Was this reply helpful? Yes No
ANB 7,250 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

My Updated formula does not have ID. What is the type of 'Network ID' in SP?

Thanks,
ANB

Was this reply helpful? Yes No
ANB 7,250 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
I tried replicating the same code with one column and it is working fine:
ForAll( Gallery10.AllItems As var, Patch( TESTING11, LookUp( TESTING11, ID = var.ID ), {Keywords: var.Keywords} ) )
Thanks,
ANB

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@ANB

but the Gallery10.AllItems

will store the values as they are stored inside SharePoint and not the updated ones inside the gallery,, am i correct? so at the end nothing will be updated.. this is based on my test.

Was this reply helpful? Yes No
ANB 7,250 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

No, This is what I have done. I have TESTING11 SP list which has Choice column Keywords and I am using that in this code because I am assuming that 'Network ID' in SP list is also Choice type. BTW you didnt confirm on that. I asked in my previous response. What is the type of 'Network ID' in SP?

Now when I select anything from choice which I have mapped to combo box in gallery, that will be patched using the above code that i have shared.
Please manually type the code rather than copy paste because it might have some spelling mistake or some extra space in column name that I gave.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@ANB NetworkID is of type Number, but i am showing a combobox to select the related Network. as i have a separate SharePoint list named Netoworks

Was this reply helpful? Yes No