Answered

Adding filter to gallery that includes two dates and an blank date

(0) Share

Report

Posted on by greylagunas87

I am trying to sort a gallery to display records based on a drop-down selection, an Empty Exit Date, Admit date is greater than a specific date picker, and if the record has an exit date, it must be between the two date pickers.

SortByColumns(

Filter(

'DataSource',

Or(

IsBlank(SourceDD),

'Referral Source'.Value = SourceDD.Selected.Value

IsBlank('Exit Date') And 'Admit Date' <= DateTo.SelectedDate,

'Exit Date' >= DateFrom.SelectedDate And 'Exit Date' <= DateTo.SelectedDate

"Program",

SortOrder.Ascending

)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @greylagunas87,

Is there a specific error you are receiving? According to your description I have made some changes below. 😊

SortByColumns( Filter( 'DataSource', //When Source is selected, filter referral source based on the dropdown IsBlank(SourceDD.Selected) || 'Referral Source'.Value = SourceDD.Selected.Value, //Either Exit Date is empty and filter based on Admit Date only //Or Filter by dates between and eq to Admit Date and Exit Date (IsBlank('Exit Date') && 'Admit Date' <= DateTo.SelectedDate) || ('Admit Date' >= DateFrom.SelectedDate && 'Exit Date' <= DateTo.SelectedDate) ), "Program", SortOrder.Ascending )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
greylagunas87 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, that worked. I wasn't receiving an error it just wasn't filtering my gallery.

Was this reply helpful? Yes No