web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Delegation warning in ...

Power Apps

Unanswered

Delegation warning in Gallery search

(0) Share

Report

Report

Posted on by Setayesh2

105

Hello,

Would someone advise me about searching in the gallery?

I get a delegation warning

If(IsBlank(txtSearch.Text),'xxx-RMA',Filter('xxx-RMA', txtSearch.Text in Status.Value Or txtSearch.Text in 'RMA No.' Or txtSearch.Text in 'Client No.'))

Thanks in Advance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Setayesh2 ,

The in Filter is not Delegable - if you use StartsWith() as below it Delegable, but in and Search are not.

Filter( 'xxx-RMA', StartsWith( Status.Value, txtSearch.Text ) || StartsWith( 'RMA No.', txtSearch.Text ) || StartsWith( 'Client No.', txtSearch.Text ) )

Also make the Default of your Text Box "" (empty string)

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @Setayesh2

Search is not a delegable function thats why you are getting delegable warning in your app. You should use either a combination of filter and search or startswith and search.

Was this reply helpful? Yes No
Setayesh2 105 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz , but still I get delegation warning

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

Like
a
(1)

Report
Copy link

Link copied!

@Setayesh2 ,
Actually, that is correct - Choice/Lookup columns cannot be filtered in a Delegable manner other than with Equals =. You can use StartsWith on the other two, but I suggest you convert it to Text and do the Choices in Power Apps (as I always do).

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation