How to iterate through the GalleryItems collection and update

Rajkiran Swain

How to iterate through the GalleryItems collection and update corresponding records in the 'PO Items' list based on the ID

ClearCollect(
    GalleryItems,
    Glry_Po_Items.AllItems// Replace 'Gallery1' with your gallery control name
);

ForAll(
    GalleryItems,
    Patch(
        'PO Items',
        LookUp('PO Items', ID = ThisItem.ID),
        {
            Title: NewPONumber
        }  
    )
);

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mohammad Hussain3y ago

Accepted answer

Hello Raj - Do not use lookup here . Instead of update , just insert the records in the list and create a another list as reference and add those reference values .

ForAll(
    GalleryItems,
    Patch(
        'PO Items',
        Defaults('PO Items'), // Defaults to create a new record
        {
             Title: NewPONumber,
            'Item Name': ThisRecord.txt_Item_Name.Text,
             Item_GUID: GUID()
        }
    )
);