Hi So I built an app and they liked it so much they wanted another one just like it.
So I had a gallery in my first app that has this code
SortByColumns(
If (
CheckboxManage.Value, Filter( 'Scheduled Courses', Category.Value = "Management"
&& (DatePicker3.SelectedDate <= StartDate || DatePicker3.SelectedDate = Blank())
&& (DatePicker2.SelectedDate >= EndDate || DatePicker2.SelectedDate = Blank()) ),
CheckboxConstruct.Value, Filter( 'Scheduled Courses', Category.Value = "Construction"
&& (DatePicker3.SelectedDate <= StartDate || DatePicker3.SelectedDate = Blank())
&& (DatePicker2.SelectedDate >= EndDate || DatePicker2.SelectedDate = Blank()) ),
CheckboxEngine.Value, Filter('Scheduled Courses', Category.Value = "Engineering"
&& (DatePicker3.SelectedDate <= StartDate || DatePicker3.SelectedDate = Blank())
&& (DatePicker2.SelectedDate >= EndDate || DatePicker2.SelectedDate = Blank()) ),
CheckboxOther.Value, Filter('Scheduled Courses', Category.Value = "Other"
&& (DatePicker3.SelectedDate <= StartDate || DatePicker3.SelectedDate = Blank())
&& (DatePicker2.SelectedDate >= EndDate || DatePicker2.SelectedDate = Blank()) ),
CheckboxSafe.Value, Filter( 'Scheduled Courses', Category.Value = "Safety"
&& (DatePicker3.SelectedDate <= StartDate || DatePicker3.SelectedDate = Blank())
&& (DatePicker2.SelectedDate>= EndDate || DatePicker2.SelectedDate = Blank()) ),
Search( Filter( 'Scheduled Courses', (DatePicker3.SelectedDate <= StartDate || DatePicker3.SelectedDate = Blank())
&& (DatePicker2.SelectedDate >= EndDate || DatePicker2.SelectedDate = Blank())), TextSearchBox1.Text, "Title" )) , "StartDate" )
This formula filters by date, by checkbox and by search box and sorts by StartDate. And if no filters are in place then all the line items in the gallery are visible.
This worked perfectly in my first app. My second app, I enter it, it does NOT return an error but also does not display anything. see pictures below. Can anyone please help!
Original App
New App
