Notifications
Announcements
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?
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.
@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
Hi @bradleyhorton
Perfect. Both the brackets and the "and" helped. Thank you
This a very old thread but I thought I would add something as it solved my problem.
I needed single brackets around my date expression. i.e.
Status eq 'waiting' and CreatedDate le addDays(utcNow(),-14,'yyyy-MM-dd') - failed
Status eq 'waiting' and CreatedDate le 'addDays(utcNow(),-14,'yyyy-MM-dd')' - worked
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 525 Super User 2025 Season 2
Tomac 324 Moderator
abm abm 232 Most Valuable Professional
