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.


Report
All responses (
Answers (