web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sharepoint list query ...
Power Automate
Unanswered

Sharepoint list query doesn't work with multible conditions

(0) ShareShare
ReportReport
Posted on by 71

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

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

JustusCk_4-1712644883988.png

 

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:
I have the same question (0)
  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    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.

     

  • JustusCk Profile Picture
    71 on at

    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'

    JustusCk_0-1712646792995.pngJustusCk_1-1712646892673.png

     

    Same email same list 

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard