Hello - I am nearly there on a filtering issue and would greatly appreciate the help of anyone to point to where I'm off base. I have a gallery where the items property is filtered based on a search bar and two drop downs created using the YouTube at: https://www.youtube.com/watch?v=kLGglidmPxg
Here is the interface that is filtering my gallery of workshops based on search bar & 2 dropdown filters. It is working as expected.
The data source of my View All Sessions dropdown is a collection of dates (colTimeFilter) that is calculated when the app starts to determine dates within this week, month, etc. The View All Sessions dropdown determines the dates that populate in the date gallery above my workshop gallery (circled in red).
My current Items property of my workshop gallery is a long If statement to filter a collection of student workshops (colStudEvents) based on the search bar (tbSearchSessions_1) & drop down controls (ddtrack & ddTimeSelection) as pasted below:
If(
//This is for all and all
ddtrack.Selected.FormText = "View All Tracks" And ddTimeSelection.SelectedText.Value = "View All Sessions",
Sort(
Search(
Filter(
colStudEvents,
!IsBlank(Date) && DateValue(Date) >= Today()
),
tbSearchSessions_1.Text,
"field_2",
"TrackText",
"field_5"
),
Date,
Ascending
),
//This is for all tracks and selected time
ddtrack.Selected.FormText = "View All Tracks" And ddTimeSelection.SelectedText.Value <> "View All Sessions",
Sort(
Search(
Filter(
colStudEvents,
DateValue(Date) >= ddTimeSelection.Selected.StartDate && DateValue(Date) <= ddTimeSelection.Selected.EndDate
),
tbSearchSessions_1.Text,
"field_2",
"TrackText",
"field_5"
),
Date,
Ascending
),
//This is for selected track and all dates
ddtrack.Selected.FormText <> "View All Tracks" And ddTimeSelection.SelectedText.Value = "View All Sessions",
Sort(
Search(
Filter(
colStudEvents,
DateValue(Date) >= Today() And Track.Value = ddtrack.Selected.FormText
),
tbSearchSessions_1.Text,
"field_2",
"TrackText",
"field_5"
),
Date,
Ascending
),
//This is for selected track and selected dates
ddtrack.Selected.FormText <> "View All Tracks" And ddTimeSelection.SelectedText.Value <> "View All Sessions",
Sort(
Search(
Filter (
colStudEvents,
Track.Value = ddtrack.Selected.FormText And DateValue(Date) >= ddTimeSelection.Selected.StartDate && DateValue(Date) <= ddTimeSelection.Selected.EndDate
),
tbSearchSessions_1.Text,
"field_2",
"TrackText",
"field_5"
),
Date,
Ascending
)
)
I would now like to incorporate an additional filter to the Items property of my workshop gallery above the ability for a user to select a date from the date gallery (gallerySessionDates_3) to further filter the workshop gallery (galleryAgenda_1).
How would I do that (without breaking what I've already built)?
Currently, the gallerySessionDates_3 consists of just a Button (Button1_4) whose OnSelect property is Select(Parent) and whose Text property is
Text(
DateValue (ThisItem.Date),
"[$-en-US]ddd"
) & " " & Text(
DateValue(ThisItem.Date),
"[$-en-US]mmm"
) & " " & Day(DateValue(ThisItem.Date))
I've tried filtering from this OnSelect property but am getting errors in scope, which is why I'm betting I need to incorporate this filter into the workshop gallery Items property instead.
Thank you to anyone who's able to point me in the right direction!
Best,
@kky1
