Filter Query - Contains() - not empty

(1) Share

Report

Posted on by PowerAppUser98

Hi there,

Just a simple question for filtering a SharePoint list via "Get Items".

The first filter looks for dates that are 7 days in the future - works fine "formatDateTime(addDays(utcNow(), 7), 'yyyy-MM-dd')"
and now I want to add a filter for all entries that are not empty/blank in the "Info" column - they just have to contain something.

Date eq 'formatDateTime(addDays(utcNow(), 7), 'yyyy-MM-dd')' and ne '' - does not work.

Any ideas how to make it work?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report
Try:

Date eq 'formatDateTime(addDays(utcNow(), 7), 'yyyy-MM-dd')' and Date ne null

You might also be interested in this YT Tutorial: How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

I’ll cover some common use cases and concepts that can help you to build better Power Automate flows.

IN THIS VIDEO:
✅ 4 Date Functions You Need to Know
✅ How to use the Convert Time Zone Action
✅ How to Get a Future Date
✅ How to Get a Past Date
✅ How to Return SharePoint Items Due in a Number of Days
✅ How to Return SharePoint Items Due within a Date Range
✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days
✅ How to Calculate the Number of Days between Two Dates
✅ How to Check for a Birthdate and Anniversary Date
✅ How to work with Dates and Times in Excel
✅ How to use a Manual Trigger with Date Input
✅ How to Output Dynamic Text with an Expression
✅ How to Check if a Date Falls on a Weekend

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
PowerAppUser98 84 on at

Like (0)

Report

@creativeopinion thank you it finally worked

Was this reply helpful? Yes No