Submitted by leader on Wed, 06/25/2025 - 14:04
Displays all the items in the status color is Blue or Yellow if nothing is in the search box,
The it will drill down by the name when the user enters name but only the items that are status "Blue" or "Yellow"
Then it sorts the gallery by the Title.
In the Gallery's Items property:
Sort(
If(
IsBlank(searchbox_3.Text),Filter('2025SummerGradCeremony',StatusColor.Value = "Blue" Or StatusColor.Value = "Yellow"),
Filter('2025SummerGradCeremony',StartsWith(Title, searchbox_3.Text) And StatusColor.Value = "Blue" || StartsWith(Title, searchbox_3.Text) And StatusColor.Value = "Yellow")),
Title,SortOrder.Ascending)