ODATA filter on Get Items returns error One or more field types are not installed properly. Go to the list settings page to delete these fields.

[KarlinOz]

I am dizzy from going around in circles with this for so long...

I am attempting to apply a filter to Get Items:

and I get the error:

One or more field types are not installed properly. Go to the list settings page to delete these fields.

I presume the list it is referring to is the list I am trying to get items out of and I presume the field it is referring to is the field I am trying to get items from. But seriously, do I want to delete that column? It's got my valuable data in it. 

As a test, I ran the Get Items with no filter, it runs fine and returns 100 items out of the list. Then I added a variable to grab the values from the field I was referring to in my failed filter attempt. It grabs the values fine:

Result:

So, to me, that seems to indicate my Employee/Value field is OK. Would that be a valid assumption?

Can anyone steer me in the direction as to why my filtering attempt may be failing?

[v-litu-msft]

Hi @KarlinOz,

Is the column Employee a Choice type one?

If so, you just need to do is use the columnName eq 'value' to filter query, for example:

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.

[KarlinOz]

Hi @v-litu-msft , thank you for your response. Actually not it's a Lookup column.

[v-litu-msft]

Hi @KarlinOz,

What's the name of the column in the sub list related to the master list lookup column?

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.

[KarlinOz]

Hi @v-litu-msft in the Master list it is called Full Name

[v-litu-msft · Accepted solution]

Hi @KarlinOz,

Please have a try this syntax:

Employee/FullName eq 'value'

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.

[KarlinOz]

Hi @v-litu-msft , OK because I have a space in the field name I tried 

Employee/Full_x0020_Name eq 'John Smith'

but the returned error was

One or more field types are not installed properly. Go to the list settings page to delete these fields.

[v-litu-msft]

Hi @KarlinOz,

OK, have you ever renamed the Full Name column?

If answer is yes, you should input field internal name into it:

Find the internal name of SharePoint column — HelpDesk for Office 365, MS Teams, and SharePoint 1.x ...

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.

[KarlinOz]

Hi @v-litu-msft , thank you for that pointer, it's the end of the day here, I'll take a look at that tomorrow.

[KarlinOz]

Hi @v-litu-msft , I must have mis-typed the previous test as when I went and checked the Full Name name is in fact 

Full_x0020_Name

so I tried it again and this time it worked! so thank you once again.

I notice that in the Employee lookup we also have other fields from the Master selected, ie Mobile No:

Is it possible to filter based on Mobile No?

[v-litu-msft]

Hi @KarlinOz,

Yes, you could have a try.

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.

[KarlinOz]

Thanks @v-litu-msft , and for the record I did try and it worked, simply by referring to the field name in the parent so 

Employee/Mobile_x0020No eq '0400000000'

worked perfectly. Thanks once again.

[Mohandar]

You might not be able to use Filter query based on lookup column in list such as I have lookup column GCRNumber referring a column Number in other table I am also using ID and other columns to be part of this lookup.

When I use GCRNumber eq 'Number' as filter query to get items I was not getting any data In Get Items. then I switched query  to other field referring in the lookup column. GCRNumber/ID eq 'ID' and boom it start working.

so If you filter query to lookup does not  work  try to use other referring fields.