cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-litu-msft
Community Support
Community Support

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.

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

Thanks so far. Andre

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,104)