Power Platform Community Forum Thread Details

My app did not have these delegation warnings for the versions using powerapps release 3.20092.39, but today the powerapps release is 3.20093.27 and it seems to have caused a new problem. This is happening in multiple applications.
On the code below I get:
"Delegation warning. The "SortByColumns" part of this formula might not work correctly on large data sets as its direct inner function blocks the delegation of all upper-level functions."

SortByColumns(
Distinct(
 If(
 !IsBlank(_filterUser) && !IsBlank(_filterApp) && !IsBlank(_filterLocation) && !IsBlank(_filterArea),
 Blank(),

 !IsBlank(_filterApp) && !IsBlank(_filterLocation) && !IsBlank(_filterArea),
 Filter(
 IC_UserSecurities,
 'Security App'.'App Name' = _filterApp,
 'Security Location'.'Location Name' = _filterLocation,
 'Security Area'.'Area Name' = _filterArea
 ),

 !IsBlank(_filterLocation) && !IsBlank(_filterArea),
 Filter(
 IC_UserSecurities,
 'Security Location'.'Location Name' = _filterLocation,
 'Security Area'.'Area Name' = _filterArea
 ),

 !IsBlank(_filterApp),
 Filter(
 IC_UserSecurities,
 'Security App'.'App Name' = _filterApp
 ),

 //default
 IC_UserSecurities 
 ), 
 'Security User'.'Full Name'
), "Result", Ascending)

This code is in a combobox Items property. It worked perfectly yesterday.

Categories:

Using Apps Using Formulas