cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KarlinOz
Helper I
Helper I

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.

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

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.

View solution in original post

12 REPLIES 12
v-litu-msft
Community Support
Community Support

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:

Screenshot 2020-12-17 154819.jpg

 

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.

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

2020-12-17 18_52_37-List Settings - Brave.png

v-litu-msft
Community Support
Community Support

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.

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

v-litu-msft
Community Support
Community Support

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.

View solution in original post

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
Community Support
Community Support

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.

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
Helper I
Helper I

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:

2020-12-18 07_36_10-Change Column - Brave.png

 

Is it possible to filter based on Mobile No?

v-litu-msft
Community Support
Community Support

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.

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
Frequent Visitor

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.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (3,013)