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 Get Items A...
Power Automate
Unanswered

SharePoint Get Items AND in Filter query

(0) ShareShare
ReportReport
Posted on by 690

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,195 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
    690 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

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 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard