how to include Text box filter

[Ungarala1]

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))

[Ungarala1]

I stuck at this code from 2 days

[WarrenBelz]

@Ungarala1 ,

You have a comma missing after TextInput1.Text - please consider taking a little time to understand the basic structure of code - this like the last item should have been fairly easy to see. 

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.

[Ungarala1]

No change after adding comma also😞

[WarrenBelz · Accepted solution]

@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.

[Ungarala1]

i need to Declare as variable in Start APP for this ?

wList

[WarrenBelz]

@Ungarala1 ,

No - it is a temporary variable within the statement - the code is fine the way it is - you can call it whatever you want, just refer to it in the second part of the code. I have a blog that may assist you in understanding it.

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.

[Ungarala1]

instead of search bar now i added buttons also for program as varproject.. it is working fine but .. once i clicked varproject button, varstutus buttons not working?

SortByColumns(
Filter(
'Notice Tracker',
'Assigned Designer'.Email = User().Email,
IsBlank(varStatus) || Status.Value = varStatus || varStatus = "All",
IsBlank(varproject) || Program.Value = varproject|| varproject = "All"
),

"ID",
Descending
)

[WarrenBelz]

@Ungarala1 ,

Is your posted question solved? If so, please mark as solution and post this question on a new thread.

[Ungarala1 · Accepted solution]

yes.. it working but small issue..

 once i clicked varproject button, varstutus buttons not working?

[WarrenBelz]

@Ungarala1 ,

You have marked your own post (which is not the solution). Please mark the post that helped you the most to solve this and post the new question on another thread.