how to include Text box filter

(0) Share

Report

Posted on by Ungarala1

184

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

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (2)

Sort by

WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Ungarala1 184 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Ungarala1 ,

That does not really help - what is the error?

Was this reply helpful? Yes No
Ungarala1 184 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Ungarala1 184 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Ungarala1 ,

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

Was this reply helpful? Yes No
Ungarala1 184 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ungarala1 184 on at

Like
a
(0)

Report
Copy link

Link copied!

I stuck at this code from 2 days

Was this reply helpful? Yes No