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?
Solved! Go to 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.
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.
Hi @v-litu-msft , thank you for your response. Actually not it's a Lookup column.
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 @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.
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.
Hi @KarlinOz,
OK, have you ever renamed the Full Name column?
If answer is yes, you should input field internal name into it:
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.
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?
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.
User | Count |
---|---|
78 | |
54 | |
52 | |
42 | |
42 |
User | Count |
---|---|
81 | |
79 | |
75 | |
67 | |
43 |