Answered

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)

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!

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