Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Get Items Filter Quer

Posted on 27 Nov 2024 15:35:56 by
Hi all,
 
I am building a flow which includes the following multiple criteria filter in Get Items:
 
 
field_3 eq 'Open' and  field_2 le 'addDays(utcNow(),-1,'yyyy-MM-dd')'
 
When I run this flow there are no results returned however, when I run the filters individually I get the results I would expect.
 
Can someone tell me why the combined filter is not working.
 
Many thanks in advance for your help.
  • Suggested answer
    EKarim Profile Picture
    EKarim 10,207 on 28 Nov 2024 at 22:55:12
    Get Items Filter Quer
    Can you confirm that there is data in your SharePoint list that actually matches the query.
     
    (field_3 eq 'Open') AND (field_2 le 'addDays(utcNow(),-1,'yyyy-MM-dd')')
     
     
    Ellis

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard