cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ungarala1
Helper IV
Helper IV

how to include Text box filter

how can i insert textbox filter in below code.. it showing as delgation warning ,if i add search function in below .

 

SortByColumns(Filter('Notice Tracker','Assigned Designer'.Email=User().Email,IsBlank(varStatus) || Status.Value = varStatus|| varStatus = "All"
),"ID",If(SortDescending1,Descending,Ascending))

2 ACCEPTED SOLUTIONS

Accepted Solutions

@Ungarala1 ,

This is valid code providing your values are valid

With(
   {
      wList:
      SortByColumns(
         Filter(
            ' Notice Tracker',
            (IsBlank(varStatus) || varStatus = "All") ||
            Status.Value = varStatus
         ),  
         "ID",
         If(
            SortDescending1,
            Descending,
            Ascending
         )
      )
   },
   Search(
      Filter(
         wList,
         'Assigned Designer'.Email=User().Email
      ),
      TextInput1.Text,
      "Program"
   )
)

I have tested it here with values from a test list. What is the error?

 

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

Ungarala1
Helper IV
Helper IV

yes.. it working but small issue..

 once i clicked varproject button, varstutus buttons not working?

 

View solution in original post

19 REPLIES 19
WarrenBelz
Super User
Super User

HI @Ungarala1 ,

Note that the top filer needs to return under your Delegation limit - Search is not Delegable (nor is the Person Field you are filtering on).

With(
   {
      wList:
      SortByColumns(
         Filter(
            'Notice Tracker',
            (IsBlank(varStatus) || varStatus = "All") ||
            Status.Value = varStatus
         ),
         "ID",
         If(
            SortDescending1,
            Descending,
            Ascending
         )
      )
   },
   Search(
      Filter(      
         wList,
         'Assigned Designer'.Email=User().Email
      ),
      YourSearchBox.Text,
      "YourSearchFieldName"
   )
)

 

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.

it is not working, i changed my text input name and column name .. showing error

@Ungarala1 ,

That does not really help - what is the error?

i added error below in code

 

 

With(
{
wList:
SortByColumns(
Filter(
'Notice Tracker',
(IsBlank(varStatus) || varStatus = "All") ||
Status.Value = varStatus
),
"ID",
If(
SortDescending1,
Descending,
Ascending
)
)
},

//error from below code as : invalid number of arguments: received 2 ,expected 3 or more

Search(
Filter(
wList,
'Assigned Designer'=Email=User().Email
),
TextInput1.Text
"Program"
)
)

@Ungarala1 ,

The error is fairly clear - you have two equals signs . . . your code (which I copied) is 

'Assigned Designer'.Email=User().Email

 

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.

still not working same error message

With(
{
wList:
SortByColumns(
Filter(
' Notice Tracker',
(IsBlank(varStatus) || varStatus = "All") ||
Status.Value = varStatus
),
"ID",
If(
SortDescending1,
Descending,
Ascending
)
)
},


Search(
Filter(
wList,
'Assigned Designer'.Email=User().Email
),
TextInput1.Text
"Program"
)
)

@Ungarala1 ,

Again, that does not help me - what is the error?

Same error

//error from below code as : invalid number of arguments: received 2 ,expected 3 or more

BCLS776
Super User
Super User

@WarrenBelz , the user has a similar question going in another thread, which is complicating the matter: https://powerusers.microsoft.com/t5/Building-Power-Apps/Search-filter/m-p/1290174#M337699

 

I'll leave it in your hands since you are already dealing with delegation through the With() statement - you're ahead of my solution.

 

@Ungarala1 it's best to stick to a single post for a question, please.

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,311)