Answered

Filter Query when Column is Blank

(0) Share

Report

Posted on by Robin_White5133

I have a SharePoint list that I want to run a filter query on in Power Automate to produce results based on 5 days after a date column and when another column is blank. So far I have this filter query but it is not producing any outcomes.

EndDate le '{formatDateTime(addDays(utcnow(),-5),'dd-MMMM-yyyy')}' and Project_x0020_Closedown_x0020_Fo eq 'null'

I have created 2 entries with the End Dates filled as 17/05/2024 & 16/05/2024. Can anyone in the Power Automate world tell me where I have gone wrong. 😀😀😀😀

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Robin_White5133

Pls try the below query:

EndDate le '{formatDateTime(addDays(utcnow(),-5),'dd-MMMM-yyyy')}' and Project_x0020_Closedown_x0020_Fo eq null

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Robin_White5133 34 on at

Like (0)

Report
Copy link

Link copied!

Many thanks Manish, those pesky inverted commas....😁

Was this reply helpful? Yes No