cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drossi90
Helper II
Helper II

ODATA filter

Hi there, I am wondering if there's a better way to write my ODATA filter.

 

Currently I have:

 

 

Trade_Id__c eq '6' and Assigned_Trader_Id__c eq '218' or Assigned_Trader_Id__c eq '313' or Assigned_Trader_Id__c eq '312' or Assigned_Trader_Id__c eq '314' or Assigned_Trader_Id__c eq '315'

 

 

What I need is the filter to look for Trade ID 6 and then any of the assigned trader ids. So i was thinking there must be a better way to group the trader ids

1 REPLY 1
Shujaath_Khan
Super User
Super User

Hi @drossi90 

Just to better group you can try below

 

(Trade_Id__c eq '6' ) and ( Assigned_Trader_Id__c in ( '218', '313' , '312' , '314' , '315' ))

 

 

 

ref: https://docs.microsoft.com/en-us/odata/webapi/in-operator

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

https://www.youtube.com/channel/UCgQWIrxj5KrZ2nlx3CDYhEg/playlists

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,088)