Filter function problem

(0) Share

Report

Posted on by ChiRomeu

Dear members,

Please kindly help to solve the following problem. (See the picture)

Best regards

Chi

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@ChiRomeu This is a delegation warning. Try replacing the StartsWith(.....) with TextInput.Text in Delacagion.Value

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@ChiRomeu ,
StartsWith() is only Delegable for Text fields (not Choice or LookUp) the only solution (other than revert to equals) is to change your field to a Text field and construct the choices in Power Apps.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ChiRomeu 14 on at

Like (0)

Report

Dear CNT,
How exactly can I replace that please?

Best regards
Chi

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@ChiRomeu ,

You need to change the field type to Single Line of Text. It would then be advisable to delete the Data Card and add a new one. The Choices are then the Items of your drop-down

[ "Choice 1", "Choice 2", "Choice 3", "Choice 4" ]

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ChiRomeu 14 on at

Like (0)

Report

Hi,
I didn´t get your point.
Could you please explain to me please?

Best regards
Chi

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@ChiRomeu ,

I am not sure how to explain it better - Choice columns have Delegation issues on both StartsWith() and Sort() and I do not use them at all unless I want to store multiple choices. If you want to solve this issue and use StartsWith() in your Filter, then the field needs to be a Single Line of Text. You can hard-code the choices in the Items of your drop-down instead as I posted.

Was this reply helpful? Yes No