cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Abigailjw91
Level: Power Up

sort by and search

Hi

 

im trying to mix the following formulas to allow the templategallery to be searched but also sort by Title:

 

SortByColumns('Application Catalogue', "Title")

 

and

 

Search('Application Catalogue', SearchInput.Text, "Title")

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: sort by and search

You can combine the two formulas. The first parameter of both Search and SortByColumns functions can either be a data source directly, or a result of a function that returns a table. In your case, you can use the following expression:

SortByColumns(
    Search('Application Catalogue', SearchInput.Text, "Title"),
    "Title")

 

View solution in original post

4 REPLIES 4
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: sort by and search

You can combine the two formulas. The first parameter of both Search and SortByColumns functions can either be a data source directly, or a result of a function that returns a table. In your case, you can use the following expression:

SortByColumns(
    Search('Application Catalogue', SearchInput.Text, "Title"),
    "Title")

 

View solution in original post

Abigailjw91
Level: Power Up

Re: sort by and search

Thank you so much!

Anonymous
Not applicable

Re: sort by and search

 

I attempted a similar process, but I get a message indicating:

 

"Suggestion: Part of this Search Formula cannot be evaluated remotely due to service limitations. The local evaluation may produce suboptimal or partial results. If possible, please simplify the formula. For more information, please see the search function documentation." 

 

And search doesn't work.I researched the https://docs.microsoft.com/en-us/powerapps/functions/function-filter-lookup and am not able to identify what it is that is missing.

 

Here is my query persay- SortByColumns(Search(Source,TextSearchBox1.Text,"Column"), "Column", If (SortDescending1,Descending, Ascending)

 

Bolded "Column" is the are in which if I hover over it the error message above displays.

 

 

Anonymous
Not applicable

Re: sort by and search

I think I resolved my problem. Here is what I did:

 

SortByColumns(Filter(Source, TextSearchBox1.Text in Column), "Column", If(SortDescending1, Descending, Ascending))

 Used filter instead of search and "in" instead of "startswith"  
  

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,429)