Mastering PowerApps Galleries: Easy Filtering & Sorting with Modern Buttons - Part 3

[@StephMarshall]

💥Button
OnSelect - Set(varSortColumn,"Title");Set(varSortDirection,If(varSortDirection=SortOrder.Descending,SortOrder.Ascending,SortOrder.Descending))
Icon - If(varSortColumn"Title","ArrowSort",If(varSortDirection=SortOrder.Ascending,"ArrowUp","ArrowDown"))
💥Gallery
-Switch(varSortColumn,"Title",SortByColumns(Filter({'DATA SOURCE'},And(Or(IsBlank(dpStart.SelectedDate),'Departure Date (Suggested live date for the content)'>=dpStart.SelectedDate),Or(IsBlank(dpEndDate.SelectedDate),'Departure Date (Suggested live date for the content)'=dpStart.SelectedDate),Or(IsBlank(dpEndDate.SelectedDate),'Departure Date (Suggested live date for the content)'

[@CarolLoughrey]

I’ve always had trouble combining sort and filter. So thank you! I’ll try this

[@StephMarshall]

I can't wait to hear how it goes for you 😻

[@CarolLoughrey]

@@StephMarshall So far I am okay up to the Switch statement. I am having a heck of a time with the date column, which is the first column in my gallery. It is called "Schedule Start Date'. Both the sharepoint list column and the list in the gallery have the same name, but no matter how I try the wording, I get an error that "Schedule Start Date" does not exist. Very frustrating. I am going to take a break and then try it with other columns and rewatch part 2 and part 3

[@StephMarshall]

I JUST saw these comments, I'm so sorry. Did you get this figured out?

[@JonEricE-n1k]

Absolutely fantastic work! This is incredibly informative and has provided me with great inspiration for my upcoming canvas app.

[@StephMarshall]

I'm so glad! 😊

[@Power_Apps_Developer]

Great.

[@StephMarshall]

Thanks!

[@shineremanan5523]

My third sort column is a lookup column . Sort is not working for lookup column.. could u pls suggest

[@StephMarshall]

I did another video on that th-cam.com/video/h5VGZ2oJJnc/w-d-xo.html let me know if you still have questions!

[@mohammedmerchant5628]

great tutorial, thanks Steph. I'm trying this out using the modern Table control to filter on multiple items & I observed that the Table control sometimes works, sometimes does not. It kind of caches the data. My expression with 1 text input and 4 dropdowns is here. I attempted different browsers, the Table simply does not filter smoothly as it should. If you have seen this before or know the possible cause, please advise:
Filter(
DemoGr12Devices,
And(
Or(
searchTextInput.Value = Blank(),
StartsWith(
SerialNumber,
searchTextInput.Value
),
StartsWith(
FirstName,
searchTextInput.Value
),
StartsWith(
StudentNum,
searchTextInput.Value
),
StartsWith(
LastName,
searchTextInput.Value
)
),
Or(
schName_drp.Selected.Value = Blank(),
School = schName_drp.Selected.Value
),
Or(
AssetType_drp.Selected.Value = Blank(),
AssetType.Value = AssetType_drp.Selected.Value
),
Or(
SummerStud_drp.Selected.Value = Blank(),
'Summer Student'.Value = SummerStud_drp.Selected.Value
),
Or(
retuDevices_drp.Selected.Result = Blank(),
DeviceReturn = retuDevices_drp.Selected.Result
)
)
)