Power Platform Community Forum Thread Details

Thank you for taking the time to read my question.

Users of my app are able to select a data range. Once selected they click on a button which sets some variables and sends them to a screen with a Column Chart on it. The Column Charts Items =

With({_Data:Sort(AddColumns(Filter(Assets,WarrantyExpireDate>=DateValue(WarrLSStart)&&WarrantyExpireDate<=DateValue(WarrLSEnd)),"_YearMonth",Text(WarrantyExpireDate,"yyyy")&Text(WarrantyExpireDate,"mm"))._YearMonth,_YearMonth,Ascending)},ForAll(GroupBy(_Data,"_YearMonth","_gYearMonth"),{_rYearMonth:_YearMonth,_rCount:CountRows(_gYearMonth)}))

In some cases the date range can return more than 500 records. When this happens the CountRows does not work correctly and is less than the total should be. I'm assuming this is a limitation of GrouBy?

I changed my apps Data row limit to 2000 and now the CountRows returns the right numbers... until the date range returns more than 2000 records?

BUT, changing the Data row limit to 2000 makes the rest of my app slow!

Is there a way around this or do I just have to live with it? Or do I limit my users on the date range so that if more than 500 records are returned, they cannot proceed? (Seems like a low number of records).

Thanks

Categories:

Building Power Apps