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?
Solved! Go to 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,
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.
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?
[removed]
What methods did you use to get around the 500 record limitation. i only have about 2000 records.
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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
204 | |
187 | |
82 | |
50 | |
37 |
User | Count |
---|---|
288 | |
243 | |
123 | |
75 | |
56 |