Answered

Filter date range with "OR" function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all.

I have a SharePoint list that is published via a PowerApp. It has two date fileds, and I have created a filter only to show items that is between start and en date. I goes like this:

Filter(OutOFOffice;Date>=StartDatePicker.SelectedDate&&Date<=EndDatePicker2.SelectedDate)

The challenge is that the EndDatePicker control is not mandatory, and my question is, can I use the "OR" function to filter if the EndDatePicker is empty or not? I am not quite sure how to manage this situation.

/Frank

Denmark

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Try this:

Filter(OutOFOffice;Date>=StartDatePicker.SelectedDate && (IsBlank(EndDatePicker2.SelectedDate || Date<=EndDatePicker2.SelectedDate))

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PowerAddict THX for super quick reply. I will try this first thing in the morning 👍

/Frank
Denmark

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Sounds good! Keep me posted!

Thanks,
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi again @PowerAddict

Your suggestion was not quite what I ended up using, but you showed me the way, and that is just as important!!! After many trial/errors attempts, I ended up with this:

Filter(DataSource; From <= Today() && (IsBlank(To) || To >= Today()))

It seems that it is working like inteded, but I will test it the next days to see if it fits my organizations needs.

Greeting from Denmark
/Frank

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Glad I could help! Keep me posted.

Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I wish I was as wise as you PowerApp gurus 🙏🙏🙏
/Frank

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Keep playing with Power Apps, you will be wiser than everyone here! There are no limits!

Thanks,
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Please accept a reply as the solution so others can find it easily.

Thanks,
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No