multiple ODATA Filter with And operator

[dobroo]

Hi @ALL,

can someone help me to run this flow:

The flow breaks by the multiple ODATA filter.

It runs if I only set one Filter Option like

"PersonalID eq PersonalID(Excel)"

or 

"Jahr eq Jahr(Excel)".

How can I run the Flow with the AND operator?

[bradleyhorton · Accepted solution]

Hi @dobroo  try removing the brackets and using and instead of AND. I've never seen brackets in OData and think there is something funny with it being case sensitive. 

[Jay-Encodian · Accepted solution]

@dobroo

Agree with @bradleyhorton - but it also looks like you are missing the single quotes

It should be formatted as: fieldName operator 'value' and fieldName operator 'value'

For example: Title eq 'Hello World' and Name eq 'Jay'

Noting there can be some variation with different field types but this is a good starting point

HTH

Jay

[dobroo]

Hi @bradleyhorton 

Perfect. Both the brackets and the "and" helped. Thank you