Unanswered

Sharepoint list query doesn't work with multible conditions

(0) Share

Report

Posted on by JustusCk

When I try to filter the get items action with the filter query like this: it works fine but as soon as I do it like this: it dosnt work anymore. And I already

turned on the experimental features and the above query came from this

it makes no sense because i tried it with the same variable and it finds items in the first query but not the second.

EDIT: Both Email eq 'Variable(email)' and Email2 eq 'Variable(email)' work when i use them alone but Email3 eq 'Variable(email)' dosn't even work when i use it alone. Ontop of that when i use only Email and Email2 togehter it also dose not work

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JustusCk

Pls try without using brackets as mentioned below:

Email eq 'a@a.com' or Email2 eq 'a@a.com' or Email3 eq 'a@a.com'

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
JustusCk 71 on at

Like
a
(0)

Report
Copy link

Link copied!
Its the same it dosnt work. This gives me no items
Email eq 'a@a.com' or Email2 eq 'a@a.com' or Email3 eq 'a@a.com'
while this gives me an item
Email eq 'a@a.com'

Same email same list

Was this reply helpful? Yes No