cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Memorable Member
Memorable Member

Re: ODATA filter not work

@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.

View solution in original post

3 REPLIES 3
Highlighted
Frequent Visitor

Re: ODATA filter not work

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

 

What am I doing wrong?

Highlighted
Memorable Member
Memorable Member

Re: ODATA filter not work

@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.

View solution in original post

Highlighted
Frequent Visitor

Re: ODATA filter not work

Thanks a lot.

 

Single qoute is the key.

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,271)