cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

I need search , sort and filter

Hello,

 

Now I need help with sort.

on sort button, a default formula is written as UpdateContext({SortDescending1: !SortDescending1}) on OnSelect property

items property of browse Gallery had "SortByColumns(
Search([@DailyEfforts], TextSearchBox1.Text, "Activity1", "Activity2", "Activity3" ), "Activity1", If( SortDescending1, Descending, Ascending ) )"

 

Now I replaced with Filter(DailyEfforts,Name=User().FullName)

 

but I need all, search, sort and filter.

How can I?

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Helper V
Helper V

Re: I need search , sort and filter

"SortByColumns(
Search(Filter(DailyEfforts,Name=User().FullName), TextSearchBox1.Text, "Activity1", "Activity2", "Activity3" ), "Activity1", If( SortDescending1, Descending, Ascending ) )"

View solution in original post

Highlighted
Community Champion
Community Champion

Re: I need search , sort and filter

Hi @Vijayendra ,

Try the below - note that there are non-Delegable filters in this (as there were before with Search and User().FullName)

SortByColumns(
   Filter(
      DailyEfforts,
      Name=User().FullName &&
     (
        TextSearchBox1.Text in Activity1 ||
        TextSearchBox1.Text in Activity2 ||
        TextSearchBox1.Text in Activity3
     )
   ),
   "Activity1",
   If(
      SortDescending1, 
      Descending, 
      Ascending
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

2 REPLIES 2
Highlighted
Helper V
Helper V

Re: I need search , sort and filter

"SortByColumns(
Search(Filter(DailyEfforts,Name=User().FullName), TextSearchBox1.Text, "Activity1", "Activity2", "Activity3" ), "Activity1", If( SortDescending1, Descending, Ascending ) )"

View solution in original post

Highlighted
Community Champion
Community Champion

Re: I need search , sort and filter

Hi @Vijayendra ,

Try the below - note that there are non-Delegable filters in this (as there were before with Search and User().FullName)

SortByColumns(
   Filter(
      DailyEfforts,
      Name=User().FullName &&
     (
        TextSearchBox1.Text in Activity1 ||
        TextSearchBox1.Text in Activity2 ||
        TextSearchBox1.Text in Activity3
     )
   ),
   "Activity1",
   If(
      SortDescending1, 
      Descending, 
      Ascending
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,500)