cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oskarkuus
Super User
Super User

Get Items Filter does not work, why?

Hi

I have a column that have this name in the webadress ending:

http://..................97D24A218D%7D&Field=PersonalNamn_x003a_ID

 

In the SP list the column is called PersonalNamnID

 

I am trying to make a filter that looks like this

 

PersonalNamnID eq '4'

 

But i just get errors

 

 

{
  "status": 400,
  "message": "The query is not valid.\r\nclientRequestId: d2e61c6e-5c94-442e-ab3a-c2fd58e9facf\r\nserviceRequestId: d2e61c6e-5c94-442e-ab3a-c2fd58e9facf"
}

 

 

I do not understand what is wrong

 

I have tried

 

PersonalNamnID eq '4'

'PersonalNamnID' eq '4'

PersonalNamn_x003a_ID eq '4'

'PersonalNamn_x003a_ID' eq '4'

 

Nothing works

 

 

 

Why?

8 REPLIES 8
ScottShearer
Super User
Super User

@Oskarkuus 

Assuming that PersonalNamnID is a number column, the following will probably work for you:

PersonalNamn_x003a_ID eq 4

If it is a text column then this will probably work:

PersonalNamn_x003a_ID eq '4'

 

Here is a link for more info

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

@ScottShearer 

None of them work.

 

The column is a look-up column or choice column... (it is the column you get from a relationship to another SP list)...

I have tried to use startswith(PersonalNamnID,4)

But still nothing works:(

Hello Team,

 

I can guarantee that this will definitely work, can you give this a try -

 

PersonalNamn_x003a_ID -eq 4

 

 If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

I get this error

{
  "status": 400,
  "message": "The expression \"PersonalNamn_x003a_ID -eq 4\" is not valid. Creating query failed.\r\nclientRequestId: 7a34b48c-f7e2-4d30-9b3e-c18dbfab39cb\r\nserviceRequestId: 7a34b48c-f7e2-4d30-9b3e-c18dbfab39cb"
}

@Oskarkuus

Can u please confirm the column type in sharepoint multichoice or Lookup? 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hello Team,

 

Can you please share a screenshot of how you are passing this configuration, I want to take a look at it.

 

Awaiting response....

It is a lookup column.

 

It displays a relationship to another sharepoint list.

@Oskarkuus

Can you make sure that you are saving the Id not Name on this column from the sharepoint setting?

If you are saving the Id then the expression should work while replacing any spaces in the field name with_x0020_

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,428)