cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mapr1981
Frequent Visitor

ODATA filter not work

Hi everybody, I have a problem with ODATA filter:

 

 

filtering 001.png

filtering 002.png

 

If I use just S_ID eq CambioS_ID it works fine, but if I use this filter not work, it show bad request.

 

Any idea? Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@mapr1981

TRy adding single quotes between ur variable like S_ID eq '9999'

 

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it

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

View solution in original post

3 REPLIES 3
mapr1981
Frequent Visitor

If I use just "S_ID eq 99999/1" it shows too "The Expression is not valid".

 

What am I doing wrong?

Mira_Ghaly
Dual Super User II
Dual Super User II

@mapr1981

TRy adding single quotes between ur variable like S_ID eq '9999'

 

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it

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

View solution in original post

Thanks a lot.

 

Single qoute is the key.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,983)