web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : LhTbKlvDidVtC4kLq/CMHl
Power Automate - Building Flows
Answered

Updating SharePoint Lookup Column

Like (0) ShareShare
ReportReport
Posted on 16 May 2023 18:03:08 by 7

Hello,

 

I have two lists, "Print Devices" and "Data Jacks", that each have a lookup column that points to the other. I'm doing this so that a user can start in either list and get additional information on the device configuration. This presents the problem of requiring extra steps to make changes, creating the risk that a user might not do both steps or could make a mistake leaving the lists out of sync.

 

What I want is for a change in one list to trigger an update in the other. The "Update Item" action won't work because you cannot enter dynamic data into the lookup field so I'm trying the HTTP request action. Here is the trigger:

fkdhjsfaioeyhug_0-1684259050197.png

And here is the HTTP request action:

fkdhjsfaioeyhug_2-1684259793935.png

I keep getting the error: "The parameter __metadata does not exist in method GetById."

I'm not very familiar with HTTP requests and have been using ChatGPT to assist but I'm just going around in circles with it. On one run, it partially worked but it created a new item instead of updating the existing one.

 

Any help would be appreciated!

I have the same question (0)
  • fkdhjsfaioeyhug Profile Picture
    7 on 17 May 2023 at 15:20:23
    Re: Updating SharePoint Lookup Column

    That's awesome- thank you!

  • Verified answer
    HenWang Profile Picture
    Microsoft Employee on 17 May 2023 at 06:42:32
    Re: Updating SharePoint Lookup Column

    Hi @fkdhjsfaioeyhug ,

     

    No need to use http way, try below flow:

    HenWang_0-1684305580196.png

     

    In my test list, there is lookup column named "lookup2", and the test_22 list(second list) has one lookup column named "lookup" directly.

     

    Nothing to add in the trigger and inside the update item action:

    HenWang_1-1684305684704.png

     

    Select the enter custom value section so that you can use dynamic content: ID

     

    It would be good after this selection.

     

    Hope this can help.

     

    BR,

    Hen Wang

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 707 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 499 Moderator

#3
chiaraalina Profile Picture

chiaraalina 312

Last 30 days Overall leaderboard
Loading complete