News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps filtering delegation

Power Apps - Building Power Apps

Answered

filtering delegation

(0) Share

Report

Report

Posted on by Khairul_Amri

39

Hi everyone,

currently I'm creating a material asset tracking apps to track material availability and validity.

But I'm having an issue with my Filter delegation. How can I solve this delegation issue? please refer snapped below.

Thank you.

All responses Img

All responses (2)

Answers Img

Answers (1)

Khairul_Amri 39 on at

Like (0)

Report

Re: filtering delegation

its work.

thank you.
Verified answer

Sohan 142 on at

Like (1)

Report
Re: filtering delegation

Hello @Khairul_Amri,
Dealing with delegation warnings in Power Apps can be tricky, especially when using the in operator. You may use this trick.
Pre-Filtering with With Function:
The delegation warning arises because the in operator is not fully delegable to your data source. To mitigate this, you can pre-filter your data using the With function.
Here’s an example of how you can structure your formula:
With({ _preFilter: Filter( Sharepoint_List, StartsWith('Title', TextSearchBox1.Text) && (IsBlank(ComboBox1.Selected.Value) || Satellite.Value = ComboBox1.Selected.Value) ) }, SortByColumns( Filter( _preFilter, collectionType in typeSelectionFilter.Value, collectionArea in areaSelectionFilter.Value ), "Created", If(SortDescending1, Descending, Ascending) ))

Replace the placeholders (Datasource, TextSearchBox1.Text, etc.) with your actual field names and variables.
I hope this helps! Let me know if you have any further questions. If this solves your question, please accept it as a solution & give it a thumbs up to help other community members find it more.
Thanks!