I have a gallery , in which items are shown, and i have added a label in it on the basis of the below formula, in which it will show true/false based on the lookup function. And i have also made visibility of the items on the basis of this label as well
" LookUp(DataSource,User().Email in ThisItem.Column1.Email,true) "
and i want the default view of my gallery to be showing items with true values first then the false ones.
below is the screenshot of the gallery.
snap of gallery
and the formula that i am trying to make it work with in 'Items' category of gallery.
SortByColumns(Search(DataSource, CProjects_TextSearchBox1.Text, "Project","ProjectCountry"),"Project", If(SortDescending1,Descending,Ascending))
in 'Default' category of gallery