ODATA Filter Problem

[PowerappsMax]

Hello, 

Below is an example of a SQL table I am trying to retrieve certain records from using an ODATA filter query.

Status	Company_Name	Value
Active	TTT	1
Active	TTT	34
Inactive	SSS	42
Active	JJJ	453
Active	XXX	23
Inactive	XXX	56

I am trying to pull records where the status is "Active" and only for records with companies, [TTT,SSS and XXX]

Is there a way to filter by an array? For example "Status eq 'Active' and Company_Name eq [XXX,SSS,TTT]"

Right now I am trying to do and statements and can't seem to figure out how to get this working correctly

Please let me know If I need to elaborate more and I apprentice any insight!

Thanks

[Ashwin7104 · Accepted solution]

Hey @PowerappsMax ,

I could think of the below logic. Please test and let know if it works for you

Status eq 'Active' and (Company_Name eq 'XXX' or Company_Name eq 'SSS' or Company_Name eq 'TTT')

Or use in operator

Status eq 'Active' and Company_Name in ('XXX','SSS','TTT')

[PowerappsMax]

Worked perfectly, Thanks a lot!