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!
