Announcements
Hi Folks,New to PowerApps and was wondering if anyone could help 🙂I want to filter a SP List called "Visitor Registration" and values in a Gallery display where "Date_Departure" is blank. Date Departure is a Date and Time Column.
Thanks!
Hey @Anonymous
So if I understand your problem you only want to show the items where the Departure date is blank right?
Kind regards
Tom
@Tom_SlosseYeah that's correct, I only want the gallery to show items that do not contain a Departure Date.
I think you could do this in the Items property of your gallery:
If(IsBlank(<Departure_Date>),SortByColumns(...))
Hope this helps and let me know if it still doesnt work
@Tom_Slosse
Doesnt seem to work....
If looks like its wanting me to name "Visitor Registration" before Departure data as it cant seem to find it???
Try this:
If(IsBlank(<DataSource>.<Departure_Date>),SortByColumns(...))
Hope this clear it, otherwise you will have to give me some screenshots of your application 🙂
Progress!Managed to get up to:
If(IsBlank('Visitor Registration'. Date_x0020_and_x0020_Time_x0020_0), SortByColumns('Visitor Registration'.Title))Says an invalided number of arguments?
The SortByColumns exepcts more parameters thats why it gives an error.
SortByColumns(<DataSource>, <Column>, <Order>)
An e.g. SortByColumns('Visitor Registration',"Title", If(SortDescending1,Descending,Ascending))
Thanks!Its accepting the formaula now, but shows no results....
Doesnt seem to like it....???
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 379 Most Valuable Professional
11manish 203 Super User 2026 Season 2
MS.Ragavendar 128 Super User 2026 Season 2
