Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Need correct syntax to update lookup column property using HTTP Request to SharePoint

(0) ShareShare
ReportReport
Posted on by 34

I have a Flow that successfully creates a document set in a SharePoint document library.  Now I need to update the properties of this document set.  I have successfully updated text or number columns but struggle with the correct syntax in the JSON part for updating a lookup column that points to the title column in another list.  It would be great if anyone can give an example or just point to an existing resource that clarifies this.

Just to be clear, only after the correct syntax for the "body" section of the Sent and HTTP Request to SharePoint action. Everything else works ok.
Flow_Question_update_docset_properties.PNG

  • AndreSchlender Profile Picture
    34 on at
    Re: Need correct syntax to update lookup column property using HTTP Request to SharePoint

    This looks promising.  I will give it a try later and update on progress.

    Thanks so far. Andre

  • Verified answer
    v-litu-msft Profile Picture
    on at
    Re: Need correct syntax to update lookup column property using HTTP Request to SharePoint

    Hi @AndreSchlender,

     

    There is a post about how to update Lookup value in the SharePoint by using HTTP request, it will help you:

    https://sharepoint.stackexchange.com/questions/84560/updating-lookup-values-with-the-rest-api/84675

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1