Power Platform Community Forum Thread Details

Patching Update to two Sharepoint tables for all selected Items in a gallery

I have a gallery (glyupload_3) which is a collection bringing two sharepoint list together. I am trying to patch back to both sharepoint lists the Uploaded Date (todays date) for all the selected lines in the gallery. The below formula only patched back the first line from the gallery to the sharepoint lists which i am aware is because it is referencing the first line in the gallery. How do i get it to loop through all the lines in the gallery which have been selected?

ForAll(
    Filter(
        glyupload_3.AllItems,
        Checkbox3_1.Value
    ) As DATA,
    Patch(
        'Requisition Main',
        LookUp(
            'Requisition Main',
            'Order Number' = Label68_143.Text
        ),
        {'Uploaded Date': DatePicker1_3.SelectedDate}
    )
);
ForAll(
    Filter(
        glyupload_3.AllItems,
        Checkbox3_1.Value
    ) As DATA,
    Patch(
        'Requisition Line Item',
        LookUp(
            'Requisition Line Item',
            'Item Number' = Label68_144.Text
        ),
        {'Uploaded Date': DatePicker1_3.SelectedDate}
    )
)
 
Many thanks
 
Chris 

Categories:

Power Apps component framework

Power Platform Build Tools

ForAll( Filter( glyupload_3.AllItems, Checkbox3_1.Value ) As DATA, With( { L143: Trim(DATA.Label68_143.Text), L144: Trim(DATA.Label68_144.Text) }, Concurrent( Patch( 'Requisition Main', LookUp( 'Requisition Main', 'Order Number' = L143 ), {'Uploaded Date': DATA.DatePicker1_3.SelectedDate} ), Patch( 'Requisition Line Item', LookUp( 'Requisition Line Item', 'Item Number' = L144 ), {'Uploaded Date': DATA.DatePicker1_3.SelectedDate} ) ) ) )

ForAll( Filter( glyupload_3.AllItems, Checkbox3_1.Value ) As DATA, With( { L143: Trim(DATA.Label68_143.Text), L144: Trim(DATA.Label68_144.Text) }, Concurrent( Patch( 'Requisition Main', LookUp( 'Requisition Main', 'Order Number' = L143 ), {'Uploaded Date': DatePicker1_3.SelectedDate} ), Patch( 'Requisition Line Item', LookUp( 'Requisition Line Item', 'Item Number' = L144 ), {'Uploaded Date': DatePicker1_3.SelectedDate} ) ) ) )

Quick Links

Leaderboard