cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmitLoh-Powerap
Kudo Kingpin
Kudo Kingpin

500 item limit in CDM entity search filter(need to switch to asp.net 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 asp.net 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?)

116 REPLIES 116

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.

GrischkePro_0-1627057675807.png

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 

GrischkePro_0-1627059033572.png

 

You can skip this part:

ClearCollect(iter,
	AddColumns(AddColumns(Filter(HundredChart,Number<=maxiter),"min",(Number-1)*500),"max",Number*500)
);

Instead use Sequence function:

ForAll(Sequence(maxiter), // creates a table from 1 to maxiter with column Value
	Collect(datasource_temp,
	Filter(datasource,
		RecordId >= firstrecord.RecordId + ((Value - 1) * 500) &&
		RecordId < firstrecord.RecordId + (Value * 500)
	)
)

so, may i create a create a collection of my 4k records table by using sequence based on my "id" column that's a number field not sequential? (i mean are numbers but not strictly progressive - 1,2,3 etc )

Its been 4 years and still no help from MS>

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,498)