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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint Get Items A...
Power Automate
Unanswered

SharePoint Get Items AND in Filter query

(0) ShareShare
ReportReport
Posted on by 742

Anyone know why this does not work?  If I use one or the other 

 

DCP eq 12 

DCPFA eq 1 

 

I get the right stuff back - but I need both criteria to get the right filter and using the 'and' keeps giving me [] value  (empty)

 

Thanks 

 

ctedesco3307_0-1684248313320.png

 

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,737 Most Valuable Professional on at

    Hi @ctedesco3307,

     

    Can you try to use parentheses around each filter and see if that works?

     

    Try:

    (DCP eq 12) and (DCPFA eq 1)

     

  • ctedesco3307 Profile Picture
    742 on at

    @Expiscornovus - I tried that - no go. Both of these columns are lookup columns. I did find out if I replace one of them with another text input column  'and' works - but I need these 2 to work together if possible . Thx for the reply! 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard