Showing results for 
Search instead for 
Did you mean: 
Kudo Kingpin
Kudo Kingpin

500 item limit in CDM entity search filter(need to switch to app if this exists for long)

500 item limit in CDM entity search filter, this makes it very dofficult to use for any business scenario(export, data analysis)

because I have 50k records and search filter may return sometimes 5k or 20k and I need to analyze this data(so export)

Currently its only exporting 500 first items which does not meet any business criteria(imagine you are doing google search and it returns only 3 items), sadly if this is permanant issue like sp list 5k limit I will have to inform this to our sponsors of the project and most likely as it does not meet business need to filter and export we will have to do app which we did not want to do.

I will atleast need some good workaround. One thing I observed is there is export data link in CDM screen(can you give me some workaround based on that?)

113 REPLIES 113

Something is wrong with your Query GrischkePro, it gives a delegation error, even when I changed the "Shifts" with my own list name. 

@amitnaik  it's weird but I think what I did (a long time ago) to overcome this was that I created a new Number column that copies the ID to "IDD" column for every item that is created (using a flow). The query I shared above was from memory but when I looked now to test it, you're right. I changed my query to IDD and no more delegation warning.


My Shifts list has 230k records at the moment and it seems to work well with IDD column.

@diego_marino whatever is easier for you 🙂 we all have our ways around the "limitations". Thus far I have managed to find an alternative ways to many of those limitations.

@amitnaik The query took some time though 



Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,987)