Patching 2 multi-select lookup columns from a form

Like (1) Share

Report

Posted on 11 Sep 2024 21:42:42 by CP-11092133-0

I figured out how to patch one multi-select lookup column to my SharePoint list but I can't figure out how to do it for my second column. How would I do it for DatacardValue24.SelectedItems from the same record? I just need help with the ForAll statement below,

ForAll(
    DataCardValue42.SelectedItems,
    Collect(
        colProducts,
        {
            Id: ThisRecord.Id,
            Value: ThisRecord.Value
        }
    )
);
Patch(
    NRGForm,
    Defaults(NRGForm),
    {
        
        DXProducts: colProducts
       
    }
);
ClearCollect(colProducts, Blank());
Set(varStep, 1);
If(varLegacy = true, Navigate(scrRedirect), Navigate(screenSuccess));
ResetForm(frmDXStep1)

Categories:

Power Apps component framework

All responses (2)

Answers (0)

CP-11092133-0 4 on 12 Sep 2024 at 00:19:48

Like (0)

Report

Patching 2 multi-select lookup columns from a form

@FLMike I've tried that but it throws errors with the second ID: ThisRecord.ID and ThisRecord.Value

\
Suggested answer

Michael E. Gernaey 38,804 Super User 2025 Season 1 on 11 Sep 2024 at 22:37:34

Like (0)

Report

Patching 2 multi-select lookup columns from a form

Hi

You are saying your ForAll works properly, you just need to add Another with another collection, so literally just duplicate that code add a new collection and add the additional Property (that needs the second collection)