Answered

Lookup column not displaying anything in SharePoint, despite holding value

(0) Share

Report

Posted on by smcdonald

I have a lookup column that's referencing a document library. It displays the ID field.

Despite a flow creating the item correctly, and putting in the ID, and it displaying the ID in an REST API Get call, it shows nothing in SharePoint. The NewDocID column is just a number column and updates correctly

Rest API call

I can manually select the ID if I edit the item.

The Rest API call output is identical after manually selecting it.

I've even tried having a seperate flow to run once the item is created to update the Lookup ID via REST, but it still doesn't display in the list

Any ideas?

Categories:

Business Process Flows

All responses (12)

Answers (1)

smcdonald 29 on at

Like (1)

Report

Lookup column not displaying anything in SharePoint, despite holding value

On reflection, I think the issue was rooted in the fact I'd created the list from an existing list, so the Lookup column came across in the copy.

I've had issues in the past with Lookups from a copy, and often had to delete and recreate. I think recreating with the same name caused issues too, which is why I had a to pick a new name for the column.
David_MA 11,517 Super User 2025 Season 1 on at

Like (0)

Report

Lookup column not displaying anything in SharePoint, despite holding value

Glad you got it working! I was just about to post something as I created a list with a lookup and a very simple flow to populate the lookup value with an HTTP request. The only thing I see different from what you did is that I am using a POST request versus your PATCH. But if it is now working for you, congrats.

I hardcoded the values to make it easy to test with several combinations and items on an existing list I had.
stampcoin 2,325 on at

Like (0)

Report

Lookup column not displaying anything in SharePoint, despite holding value

@smcdonald Hi,

Glad to hear that, Please mark this as answered, this is the way how we support the Author Tom Riha

This case will also help the others , and lead them to visit the article.

thanks for your understanding.
Verified answer

smcdonald 29 on at

Like (0)

Report

Lookup column not displaying anything in SharePoint, despite holding value

I've got it working now, but I had to delete DocID and create a new one with a new name.

I think there was something wrong in the back end, because I've not changed the flow and it now works.

Thanks for your help.
smcdonald 29 on at

Like (0)

Report

Lookup column not displaying anything in SharePoint, despite holding value

NewDocID only exists because I wanted to see if the actual number I'm trying to input into DocID was working.

Even putting in a manual number, which does exist in the lookup because I can manually select it by editing the item, it doesn't work

{
"formValues": [
{
"FieldName": "DocID",
"FieldValue": "50"
}
]
}
stampcoin 2,325 on at

Like (0)

Report

Lookup column not displaying anything in SharePoint, despite holding value

@smcdonald Hi,

Your logic is odd.

You try to assign a number column ( NewDocID) to a lookup DocID.

You have to make sure that NewDocID value exist in you Documents library.

The FieldValue should be always from one of the ID from your Documents library.
smcdonald 29 on at

Like (0)

Report

Lookup column not displaying anything in SharePoint, despite holding value

Not working here. Bear in mind my Lookup column is displaying the ID number of the lookup list

Does that make any difference?
CU10061430-0 6 on at

Like (0)

Report

Lookup column not displaying anything in SharePoint, despite holding value

When creating SharePoint columns names, some are not it actual names you have provided it.

If you go to List, List Settings.

Column Visibility Setting within here you should see your column internal names try that column name for DocID.
stampcoin 2,325 on at

Like (0)

Report

Lookup column not displaying anything in SharePoint, despite holding value

@smcdonald

Did a test on my side. works like a charm.
smcdonald 29 on at

Like (0)

Report

Lookup column not displaying anything in SharePoint, despite holding value

That looks like it's done something, because the ID appears in version history

But it doesn't show in SharePoint.

But I can select it