How to Update a SharePoint List Lookup Column in Power Apps

How to Update a SharePoint List Lookup Column in Power Apps

 

How to Update a SharePoint List Lookup Column in Power Apps

Welcome to this comprehensive guide on how to effectively change the values of a SharePoint list lookup column using Power Apps. As businesses expand, the need for efficient data management grows. Utilizing SharePoint and Power Apps together is a powerful combination for such tasks. In this guide, we will walk you through the process of updating a SharePoint list lookup column, using our focus keyword: SharePoint list lookup column.

Objective

The aim is to modify the “BranchLocationReference” column (of type Lookup) from “Fargo, ND” to “Minneapolis, MN” in a SharePoint List named “InspectionSites“.

Input Data

InspectionSites (SharePoint List)

ID InspectionTag ExaminationDate BranchLocationReference
1 Quality Review 11/7/2020 Fargo, ND

BranchAddresses (SharePoint List)

ID BranchPlace
1 Fargo, ND
2 Minneapolis, MN

Power Apps Patch Function


Patch(
    'InspectionSites',
    LookUp('InspectionSites', ID=1),
    {
        BranchLocationReference: {
            Id: 2,
            Value: "Minneapolis, MN"
        }
    }
)
    

Alternative Method


Patch(
    'InspectionSites',
    LookUp('InspectionSites', ID=1),
    {
        BranchLocationReference: {
            Id: 2,
            Value: LookUp('BranchAddresses', ID=2, BranchPlace)
        }
    }
)
    

Output

InspectionSites (SharePoint List)

ID InspectionTag ExaminationDate BranchLocationReference
1 Quality Review 11/7/2020 Minneapolis, MN

Use-case Scenario: Utilizing Combo Box

Here’s how to patch a value found in a combo box to a Lookup field using Power Apps:


Patch(
    'InspectionSites',
    LookUp('InspectionSites', ID=1),
    {
        BranchLocationReference: ComboBox_LocationSelector.Selected
    }
)
    
Reference: 
  1. Patch function
  2. LookUp functions
  • Updating a SharePoint list lookup column is essential in managing business data more effectively.
  • Power Apps offers a streamlined approach to update SharePoint lookup columns, enhancing productivity.
  • Mastering the update of SharePoint lookup columns in Power Apps leads to better data accuracy and workflow efficiency.
  • Utilizing the patch function in Power Apps to update SharePoint lookup columns is a key skill in modern business environments.

 

Following this guide should help you master the patching of a SharePoint list lookup column using Power Apps. Remember, data management is crucial in today’s business landscape, and having the skills to manipulate such data is invaluable.

Still facing challenges? Or need more advanced solutions? We understand that sometimes technical hurdles can be overwhelming. Contact us today for expert assistance. We’re here to help and guide you every step of the way.

Conclusion

In conclusion, SharePoint and Power Apps provide a formidable duo for business solutions. Mastering the techniques of data manipulation, such as updating a lookup column, places you ahead in the digital transformation journey. We’re here to support you in that journey. Reach out and let’s achieve greatness together!

About The Author