I've previously written about delegation in these threads:
Recently @PaulD1 posted a video in which he presented another solution for overcoming the 500 record limitation using nested galleries. It reminds me of @hpkeong's use of pagination. This has inspired me to create a new solution for not only reading >500 records, but performing aggregate functions >500 records and filters.
Change Slider1.Min to: 100 Change Slider1.Max to: 500 Change Slider1.Default to: 100
AddColumns( Filter(Primes, Number<=RoundUp((lastRecord.RecordId-firstRecord.RecordId)/Slider1.Value,0)
), "min",(Number-1)*Slider1.Value, "max",Number*Slider1.Value )
Filter(datasource, RecordId>=firstRecord.RecordId+ThisItem.min, RecordId<firstRecord.RecordId+ThisItem.max )
At this point, you should be seeing 100 records in each child gallery until it reaches the n number of groups of 100.
In the next reply, I'll be describing how to perform aggregate functions upon this nested gallery scheme.
I have seen the blog, too and even another Video on Youtube (about an hour video) on the same topics.
Glad to have another solution with even shorter and easier to understand scenario.
I will try this whenve time allowed.
I remmeber i have used both Pagination and Timer to resolve this issue and another wishing that Delegation can always be improved even for CDS for:
- ! (Not)
Have a nice day.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand