Filter CDM service limitation (delegation in 2.0.531)

[mr-dang]

PowerApps had a 500 row limitation for CDM, meaning if you did a filter, you could pull up 500 records. I circumvented this by making a temporary collection in which I pulled in 500 records at a time from the original source. My app then ran on a temporary image of the original datasource.

Right now, CDM is displaying a service limitation for my work around. It is not successful in drawing in even 500 records.

I get the squiggly blue line for service limitation even for something as simple as:

Filter(datasource, column=variable)

I can achieve Filter(datasource, column=1) using a concrete number instead of a variable. But that's not useful since I need it to change.

I also get the blue line for:

Filter(datasource,Title=Gallery1.Selected.Title)

This is a cornerstone of what I do for filtering. PowerApps should be able to handle that easily though.

The datasource in question has over 5000 records. It is my bigggest datasource. Is there a new limitation on Filtering in 2.0.531?

[rgruian · Accepted solution]

Mr-dang,

We are working to resolve the first limitation and category of warnings (involving context variables). In the mean time, as a workaround, may I suggest you pipe the value of that variable into e.g. a textbox control, and use the output of that control in your query:

    Textbox33.Text = variable

    xyz.Items = Filter(datasource, column=TextBox33.Text)

The second one we are still investigating. In the mean time, the same workaround applies here as well (refer to gallery.Selected indirectly via a Textbox control).

    Textbox33.Text = Gallery1.Selected.Title

    xyz.Items = Filter(datasource,Title=Textbox33.Text)

I hope this helps.

[mr-dang]

I used your solution and it worked. Thank you.

What are the prospects of being able to reference the variable again in future versions of PA? Do you recommend I use textboxes from here on out?

[mr-dang]

[removed]

[amarion]

What methods did you use to get around the 500 record limitation. i only have about 2000 records. 

[mr-dang]

Hi @amarion,

At the time of writing my original post in this discussion, I was using a method of pulling in 500 records at a time based on information in a TextBox (Label) since variables were buggy. That was resolved so variables are okay again.

As of right now though, I pull in 500 records at a time from a CDS entity using this method:
https://powerusers.microsoft.com/t5/PowerApps-Forum/500-item-limit-in-CDM-entity-search-filter-need-...

This works for CDS because the RecordId field is validated for values. This will not work for Excel because you can't validate a field--everything is considered Text.