cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Re: Maximum number of items reached

HI @iAm_ManCat 

You provided me with an excellent solution here, and sorry for reaching out on an already answered question (I can create a new one if required) but thought it was easier to ask here with all the info in this?

Is there anywhere I can search the gallery, via a search box as opposed to users scrolling down to items, which could be around 1000 items?

 

Thanks

Highlighted
Super User
Super User

Re: Maximum number of items reached

Hey @Lefty,

 

Absolutely!

 

You can use something like the following if you want it to search within one column, with ColumnName1 being that column:

 

SortByColumns(
              Filter(
                     'List 2',
                     Len(SearchTextInput.Text)=0
                     ||
                     Startswith( ColumnName1, SearchTextInput.Text)
              ),
              "Title",Ascending
)

 

 

Or you can expand it further using more || cases:

 

SortByColumns(
              Filter(
                     'List 2',
                     Len(SearchTextInput.Text)=0
                     ||
                     Startswith( ColumnName1, SearchTextInput.Text)
                     ||
                     Startswith( 'Column Display Name 2', SearchTextInput.Text)
                     ||
                     Startswith( ColumnName3, SearchTextInput.Text)
                     ||
                     Startswith( ColumnName4, SearchTextInput.Text)
              ),
              "Title",Ascending
)

 

You'll notice the first condition its checking is if Len (length) of the text is zero, this is so that if there is nothing searched then the gallery is not filtered, otherwise || filter by the following rules.

 

I've also added an example using the display name of a column into the second example so that you can use that if needed.

 

Let me know if you run into any issues when doing this, happy to help

 

Cheers,

ManCat


@iAm_ManCat

Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Highlighted
Post Prodigy
Post Prodigy

Re: Maximum number of items reached

@iAm_ManCat 

Amazing, this forum is brilliant, thanks to people like you.

I managed to figure out something that works, and its sort of what you have provided, but yours is by far better, so i'll look to implement yours

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,553)