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.

(0) Share

Report

Posted on by KarlinOz

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

I am attempting to apply a filter to Get Items:

2020_12_17_11_01_07_Edit_your_flow_Power_Automate_Brave.png

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:

2020_12_17_11_11_00_Edit_your_flow_Power_Automate_Brave.png

Result:

2020_12_17_11_16_30_Run_History_Power_Automate_Brave.png

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?

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KarlinOz 89 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KarlinOz 89 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
KarlinOz 89 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 documentation (plumsail.com)

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.

Was this reply helpful? Yes No
KarlinOz 89 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KarlinOz 89 on at

Like (0)

Report
Copy link

Link copied!
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?

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No