Power Platform Community Forum Thread Details

I'm trying to sort a gallery based on

DaysSinceLastVisit //Number of days since last visit

This column has a NULL if the location has no recorded visits

I'd like to force these locations to the top of the gallery.

Any suggestions?

Thanks

Steve

Sort(
Filter('[checklist].[HierarchyWithLastVisit]',(CM_Email=vCurrentUser.Email) &&
(StartsWith(StoreType,ThisType) &&
(StartsWith(StoreId,TextSearchBox_1.Text) ||
StartsWith(STORE_NAME, TextSearchBox_1.Text) ||
StartsWith(CITY, TextSearchBox_1.Text))
)),DaysSinceLastVisit,Descending)

Categories:

Building Power Apps

Hi @Sjj9166 ,

You can change the order to be Ascending, then these Null records will be in the top of gallery.

If you want to keep order to be Descending, I think the only way is to store the sorted items (Null record at the top) to the new collection, then display it in the gallery.

You can try to put the following codes to OnSelect of the Sort button, when click it, it will create a new collection that sorts as your expectation

ClearCollect(
 myGalleryCollection,
 Filter('[checklist].[HierarchyWithLastVisit]',...,
 DaysSinceLastVisit=Blank()
 )
);
Collect(
 myGalleryCollection,
 Sort(
 Filter(
 '[checklist].[HierarchyWithLastVisit]',
 ...,
 DaysSinceLastVisit<>Blank()
	),
 DaysSinceLastVisit,
 Descending
 )
);
Set(Var_Sort,true)

Also set the following formula to items of gallery, when clicking the button, change Items of gallery to myGalleryCollection.

If(Var_sort, myGalleryCollection, '[checklist].[HierarchyWithLastVisit]')

Best regards,

Sik

Community site session details

How to sort gallery Descending with Nulls at top?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates