Unanswered

Explain how to create a new SharePoint List item that has a Lookup column

(0) Share

Report

Posted on by Mattpst

183

Hi,

Could someone explain how to create a new SharePoint List item that has a Lookup column? I've looked at dozens of "resolved" posts and nothing seems to work. I am trying to create a SharePoint list item that has a lookup column from another list (in the same site).

I first query the the lookup field:

Then.... I reference the ID of this in a Create action:

The flow completes, and I can see the ID referenced in the output but the list doesn't update:

I've also tried creating the list item and then trying to update with the lookup value, but that has the same result. Am I doing something fundamentally wrong?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@Mattpst Hi,

You can add 'Send an HTTP request to SharePoint' for updating the lookup column.

Method: POST Uri: _api/web/lists/GetByTitle('<ListName>')/items(<ItemID>)/validateUpdateListItem Body: { "formValues":[ { "FieldName": "<FieldToUpdate>", "FieldValue": "<ValueToUpdate>" } ] }

for example:

Was this reply helpful? Yes No
Mattpst 183 on at

Like (1)

Report

Thanks @stampcoin I'll give this a try!

Was this reply helpful? Yes No