cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dynamicsedge Power Participant
Power Participant

Re: 500 item limit in CDM entity search filter(need to switch to asp.net app if this exists for long

@liad-nizri 

 

1. Do you get the Yellow Triangle (delegation warning)?

 

2. Usually the limit is 500. Did you change the limit to 2000?

 

3. The limit does not apply unless you are using query that does not support delegation to the data source. That means PowerApps is doing the work itself instead of using the data source, so PowerApps has to impose a limit on those types of queries. Do you get the Yellow Triangle warning? Check by clicking the Stethoscope Icon (App Checker).

 

4. How to get rid of the warning - this depends on your specific case - first, do you get the warning?

 

 

sarveshshinde15 Advocate IV
Advocate IV

Re: 500 item limit in CDM entity search filter(need to switch to asp.net app if this exists for long

Hello Mr-Dang,

Thank you so much for this traditional paging logic. 

I had a scneario where I needed to use this with SharePoint list datasource. It doesnt work with it. Do you have any idea or alternative for SharePoint list?

 

I need to use one of the non-delegable operator In while fetching data from large sharepoint list. But it doesn't work as expected because of delegation. Could you please show some pointers?

Power Apps
Power Apps

Re: 500 item limit in CDM entity search filter(need to switch to asp.net app if this exists for long

Hi @sarveshshinde15,

I start with an approach of using the right data source for the right job. If your data needs are very heavy, then your data should reside in SQL, CDS, or something on the same level. These connectors support more delegable queries like the in operator.

 

If the data needs of a problem you are solving are simpler, then you can work within the boundaries of the SharePoint connector, which can be browsed with StartsWith and EndsWith today.

lseow
Frequent Visitor

Re: 500 item limit in CDM entity search filter(need to switch to asp.net app if this exists for long

Hi @Mr-Dang-MSFT ,

 

I appreciate your input.  Our dataset is around 4000 records or less and our source would have to be from Excel. Would your recommended approach using Flow work?

 

Thanks,

Lilian

amitnaik
Regular Visitor

Re: 500 item limit in CDM entity search filter(need to switch to asp.net app if this exists for long

@Mr-Dang-MSFT  This is the code, I have used, but the collection is frozen at 2000. I tried both with 1000 and 500 maxiters but it does not go above 2000 records. Please help. 

 

UpdateContext({FR: First('Road Map')});
UpdateContext({LR: First(Sort('Road Map',ID,Descending))});
UpdateContext({MaxIter: RoundUp((LR.ID-FR.ID)/1000,0)});

ClearCollect(HundredChart,1,2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100);
ClearCollect(iter,
AddColumns(AddColumns(Filter(HundredChart,Value<=MaxIter),"mins",(Value-1)*1000),"maxx",Value*1000)
);

Clear(RM);

ForAll(iter,
Collect(RM,
Filter('Road Map',ID>=FR.ID+mins && ID<FR.ID+maxx)
)
)

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (7,298)