How to filter gallery

[cjs321]

Hi,

I have a gallery which i would like to filter / sort, but i'm struggling to get the syntax correct.

The datasource is called 'Visitors'.

The syntax i'm currently using is: Filter(Visitors,IsBlank(TimeOfDeparture)

I'd like the gallery to be sorted by date order from the 'TimeOfArrival' column.

Please help?

Kind Regards,

Connor Simpson

[RandyHayes]

SortByColumns(Filter(Visitors,IsBlank(TimeOfDeparture), "TimeOfArrival")

[cjs321]

That didn't work 😞

Attached screenshot

[RandyHayes · Accepted solution]

Do as I say, not as I do! 

There is a Typo in the posting. You're missing a paren (or I was if you copied and pasted).

SortByColumns(Filter(Visitors,IsBlank(TimeOfDeparture)), "TimeOfArrival")