Unanswered

Column does not exist Sharepoint Get items filter

(0) Share

Report

Posted on by MaksMaj

Hello,

I have OData filter on SharePoint Get items, i get an error 'Column does not exist'. I am using internal name and I still get an error.

I've already tried to use Compose to check the name of the column, but it's identical to the one I am using:

Can someone explain what am I doing wrong?

Thanks!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

Hi @MaksMaj

Pls share the data type of the field in SharePoint and also share the screenshot of the "Get items" action in edit mode (mask the site url or other sensitive info)

Thanks

Was this reply helpful? Yes No
MaksMaj on at

Like (0)

Report

Hi @ManishSolanki ,
Data type of the field is Lookup, it connects to single line of text column.

Here is get items:
Thanks

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @MaksMaj

Thanks for sharing the information.

Pls check out the below sample:

SharePoint list

Get items action:

LookupCol/Title eq 'Area 1'

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
MaksMaj on at

Like (0)

Report

Hi @ManishSolanki ,
Now i get diffrent error.

I don't see where this filter query is invalid. I tried also this option:
Column that i want to get to and to which lookup is connected:

Thank you for your help

Was this reply helpful? Yes No
MaksMaj on at

Like (1)

Report

Hello,

I've found a workaround. Using column name with space ("Severity Level") worked, column was recognised, but filter still didn't want to work, so i deleted part of the filter query with Severity Level recognision, and made condition using activity condition.

Thank you @ManishSolanki for your advise

Was this reply helpful? Yes No