ForAll gallery items will get the last gallery item values

[johnjohn123]

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?

[johnjohn123]

@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

[ANB]

Ok that is what It has different from my logic. I tried again with quick repro. I created one new list as Network:

Slight change in code:

ForAll(
    Gallery10.AllItems As var,
    Patch(
        TESTING11,
        LookUp(
            TESTING11,
            ID = var.ID
        ),
        {NetworkId: var.ComboBox4.Selected.ID}
    )
)

And it patches the Network ID to parent SP list. So, Try using this code:

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

 NOTE: Please manually type the code, rather than copy paste.

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

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

[johnjohn123]

 i am not sure how you are accessing the components inside the var??? as in my case i only get the sharepoint properties:- 

so var does not contain a property named 

PrintOrderNetworkComboBox

or a property named 

PrintOrderQuantityForEachartwork

please do not tell me it is working at your end???@ANB

[ANB]

Yes, It is working for me:

Check this also:

And the patch also patches the data for this column in parent SP. Below You can see the combo box within gallery:

Thanks,

ANB

[johnjohn123]

@ANB  in you case ComboBox4 is a SharePoint column in my case it is just a ComboBox inside the gallery.. i posted my full code and screen shot of the current gallery previously .. you are working on totally different case than mine. thanks

[ANB]

Hi @johnjohn123 , No it is not the Column in my SP List, ComboBox4 is the name of control name which is within my gallery that is what I am trying to explain here. Gallery.AllItems allow you select the controls also.

And I understand what you are looking for and based on that only i gave the code.

Thanks,

ANB

[johnjohn123]

@ANB but in my case it does not, not sure what is the differences between the environment you are working at and my environment... could this by that my controls are inside a Container? as follow:-

[ANB]

This the screenshot of my list column and there is no such column.

You need put the control name after var. Example:

PrintOrderQuantity.Text
PrintOrderQuantityForEachartwork.Text
PrintOrderNetworkComboBox.Selected.ID

Considering PrintOrderQuantity, PrintOrderQuantityForEachartwork and PrintOrderNetworkComboBox are the control name that you have used in gallery and I can see the name also in your screenshot.

Thanks,

ANB

[johnjohn123]

@ANB i added the container inside the gallery to make the gallery responsive.. so now the issue I am facing how I can access the controls which are inside the gallery container inside the ForAll?

[ANB]

@johnjohn123  One thing i suspect is that, can you make the PrintOrderQuantity control which is within your gallery to number type:

And the try this:

ForAll(PrintOrderDetailsGallery.AllItems As var,
       Patch('Printing Orders Details',
          Lookup('Printing Orders Details', ID = var.ID),    
        {  
            Quantity: var.PrintOrderQuantity.Text,
           'Quantity Each Artwork':var.PrintOrderQuantityForEachartwork.Text,
           'Network ID':var.PrintOrderNetworkComboBox.Selected.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