You’re offline. This is a read only version of the page.
415
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."
Share
ReportSortByColumns(
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.
It appears that powerapps may be having an issue actually detecting all delegation issues in complex formulas. I would recommend going into settings and temporarily changing your delegation limit to 1, so that you can see everywhere that will be a problem regardless of how many records you have in the table or where the warnings say the delegation problems are.
All responses (
Answers (
