web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate SharePoint Get Items A...

Power Automate

Unanswered

SharePoint Get Items AND in Filter query

(0) Share

Report

Report

Posted on by ctedesco3307

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

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Expiscornovus 33,737 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @ctedesco3307,

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

Try:

(DCP eq 12) and (DCPFA eq 1)

Was this reply helpful? Yes No
ctedesco3307 742 on at

Like (0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No

Join the conversation