Powerfx GroupBy Records Issue

Like (0) Share

Report

Posted on 22 Mar 2025 03:42:42 by PPSeason80

It seems that, despite no delegation issues, GroupBy function only considers the first "few thousand" records.

Case: I queried my data source with Filter function and it returned approx. 10k records. I stored those records in a screen context variable.

I then used GroupBy on the said screen context variable, using the documented parameters of the function. The function did not present any errors. But, after looking at the result, it only ended up aggregating the first 2k rows or so and yielded an incomplete result.

Anyone else notice this issue?

Categories:

Power Apps component framework

I have the same question (0)

All responses (3)

Answers (0)

BCBuizer 22,366 Super User 2025 Season 2 on 22 Mar 2025 at 12:30:16

Like (0)

Report

Powerfx GroupBy Records Issue

Hi!

The GroupBy() function is strictly non-delegable and hence subject to the Data Row Limit, regardless of the data source (https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview#nondelegable-functions).

Not having a delegating warning unfortunately doesn't mean that all your formulas are delegable. For instance, for collections no warning are shown (https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview#delegation-and-collections), despite the ClearCollect function also not being delegable).

This means you will have to find another solution to display your data. Perhaps you can elaborate what you are trying to achieve so we can look for a solution.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
PPSeason80 8 on 22 Mar 2025 at 12:42:26

Like (0)

Report

Powerfx GroupBy Records Issue

in our case, we are a large organization that is looking to adapt PowerApps into our workload. This is extremely limiting for us. Are there any efforts underway to remove delegation limits on these functions? If so, when?

Was this reply helpful? Yes No
BCBuizer 22,366 Super User 2025 Season 2 on 22 Mar 2025 at 13:52:10

Like (0)

Report

Powerfx GroupBy Records Issue

Hi @PPSeason80,

I'm not aware of any effort to make this function delegable. However, I can't think of a scenario where this much data is needed in Power Apps. In case you want to include any type of reporting, usually Power BI would be the way to go and it can be embedded in Power Apps as well.

In case you are interested, my offer to look at a way to make this work still stands if you can explain what it is you are trying to achieve.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No