Adding a searching function to my gallery

(0) Share

Report

Posted on by honganhuynh1

302

I have a gallery with the items code - on start of my app it sets varFolderPathCurrent to a path I set.

How do i filter Gallery1 to if Searchbox1 is empty then just filter 'Folder path' = varFolderPathCurrent
but if Searchbox1 isn't empty it should filter Hospice by StartsWith(Name,Searchbox1.Value)

If the searchbox is empty i want it to just display the varFolderPathCurrent if not I want it to filter by the entered text in the search box

SortByColumns(
 Filter(
 Hospice,
 'Folder path' = varFolderPathCurrent
 ),
 "{IsFolder}",
 SortOrder.Descending,
 "{Name}",
 SortOrder.Ascending
)

All responses (1)

Answers (1)

Verified answer

AndrewR1 1,572 Super User 2025 Season 1 on at

Like (0)

Report
Re: Adding a searching function to my gallery

Hi @honganhuynh1 you can do the follwoing:

SortByColumns( Filter( Hospice, StartsWith(Name,Searchbox1.Text), 'Folder path' = varFolderPathCurrent ), "{IsFolder}", SortOrder.Descending, "{Name}", SortOrder.Ascending )

If the search box is blank this should still display all records that meet 'Folder path' = varFolderPathCurrent

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks

Andrew