In this blog, we are going to see how to use a Patch function to update a SharePoint lookup column in Power Apps.

In a SharePoint list we have a column EquipmentNeededLookUp, our goal is to update EquipmentNeededLookUp (Lookup type) from Flip Charts to Laser Pointer.

Input

Meeting Request (SharePoint List).

ID MeetingTitle EquipmentNeededLookUp
1 Appraisal Meeting Flip Charts

Equipment Master (SharePoint List).

ID Equipment
1 Flip Charts
2 Laser Pointer
3 Microphones

Patch Function Code

Patch('Meeting Request', LookUp('Meeting Request', ID = 1), {
    EquipmentNeededLookUp: {
        Id: 2,
        Value: LookUp('Equipment Master', ID = 2, Equipment)
    }
})

Output

Meeting Request (SharePoint List).

ID MeetingTitle EquipmentNeededLookUp
1 Appraisal Meeting Laser Pointer

There is another way to Patch a value found in a combo box to a Lookup field.

How To Patch A SharePoint Lookup Column In Power Apps

Patch Function Code

Patch('Meeting Request', LookUp('Meeting Request', ID = 1), {
    EquipmentNeededLookUp: ComboBox_EquipmentNeeded.Selected
})

That’s it, you have seen how to use a Patch function to update a SharePoint lookup column in Power Apps. Feel free to fill up the comment box below if you need any further assistance.