Unanswered

"Advance Search"

(0) Share

Report

Posted on by Steffijeff

Good afternoon everyone.

I currently have an app with a gallery that is linked to a SharePoint list. I have ordered the list in descending order so the most recent entries appear at the top of the gallery. I currently have a text input box which allows the users to search a number of columns. This is the formula I am using and it works great.

Search(Sort('SPList','Column1',Descending), Searchbox.Text,"Column2", "Column3", "Column4")

I would like to add an "Advanced search" capability so that users can filter using several dropdown options (based on status of the item i.e open, closed, pending) as well as the text input. I must also retain the sort function so only the most recent items appear and are searched.

I have figured out how to perform the advance search on it's own but I need it to work alongside the sort function too and this is where I am coming unstuck.

Any suggestions are greatly welcomed.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@Steffijeff

You simply need to put your criteria inside the formula you have.

Sort( Search( Filter('SPList', creiteriaForFiltering), Searchbox.Text,"Column2", "Column3", "Column4" ), 'Column1', Descending )

I hope this is helpful for you.

Was this reply helpful? Yes No
Steffijeff 36 on at

Like (0)

Report

Hi @RandyHayes

Thank you, sorry, I don't think I was clear enough. What your solution is doing is applying the filters first and then sorting the results in descending order. What I need is to sort the SharePoint List so only the most recent entries are pulled through to my app and the filters are then applied to those.

In essence, I'm looking for a way around the 2000 items limit. But every solution I've tried so far applies the filters to the first 2000 items in my list, not the most recent 2000 items.

Thanks
Steph

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@Steffijeff

You can shuffle around the functions any way that you need.

If you are looking for the most recent 2000 items, then move your sort into the middle.

Sort( Search( Filter( Sort('SPList', Created, Descending), criteriaForFiltering ), Searchbox.Text,"Column2", "Column3", "Column4" ), 'Column1', Descending )

They can be shuffled any way that helps achieve what you need.

Was this reply helpful? Yes No