Groupby need getting proper results

(0) Share

Report

Posted on by Riyaz_riz11

4,150 Super User 2026 Season 1

Hi all,

I have one query regarding group by,

i have data present in dataverse table it contains 1lakh of data, now i need to use groupby and get the value, but while trying the data what am getting is not exact match, if i use delegation limit 2k i will be getting different result and 1k if i give diff results, i have tried distinct but same result, any alternative solution is there.

@WarrenBelz

Thanks,

Riyaz

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

BoboLee 33 on at

Like (0)

Report
Copy link

Link copied!

1. Use supported delegated filter otherwise only 2k rows could be returned
2. Use power automate flow with pagination

Was this reply helpful? Yes No
Riyaz_riz11 4,150 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I was not displaying data just i need to get countrows based on distinct or groupby columns

Was this reply helpful? Yes No
BoboLee 33 on at

Like (0)

Report
Copy link

Link copied!

Check the activity when the piece of code executes with monitor. I'm afraid you will find the data will be returned and the result you want is based on the returned data. The solution is using a delegated way so pls make the your filter conditions are delegated

Was this reply helpful? Yes No