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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.