Announcements
Hi,
I have a CDS data table with about 400,000 records and I'm trying to sort a single column. However, it seems even though the filter function is delegable, it cannot seem to filter this much data and either doesn't show anything or doesn't filter it at all. Any solutions?
Hi @dsipowerapps
Could you please share a little more about your scenario?
What field are you trying to filter? What control is the filter being used on? What formula are you using now?
Thanks!
(deleted since SKH already responded)
Sorry @SeanHenderson , should've given some more details. I have a CDS entity called APTH containing transaction history for a vendor. When the user searches the app and clicks on a vendor, then clicks the vendor history button, I want to filter the vendor history table to just the vendor they had selected. When they click this button it creates a global variable called "vendor" and sets it to VendorCardValue1 as a text data type. Then, on the vendor history screen, I set the items property on the data table to Filter(APTH, VendorCardValue1.Text = vendor). However, this either results in nothing showing up in the data table or simply just not even sorting it at all.
@dsipowerapps
How are they getting to the details screen in the first place? Are they selecting that vendor from a gallery? If so, you can skip the variable and just set your Items property of the data table to Gallery1.Selected.Name (or whatever your gallery name and the company name on your entity are). Then your History button could just navigate to this data table. Then add a back button on the data table screen to go back to the gallery.
---Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."
@SeanHenderson
Yes from a gallery that's connected to a separate entity called APVM, this entity contains the vendor and vendor details. The APTH entity is the transaction history for each of those vendors which is connected to the data table. I got rid of the variable and changed the Items property to "Filter(APTH, APVMBrowseGallery.Selected.Vendor = APTHDataTable.Selected.Vendor)." However, even though this does not give any errors, it simply will not render any of the filter data and returned "We didn't find any data to show at this time."
Try:
Filter(APTH, Vendor = APVMBrowseGallery.Selected.Vendor)
Still left me with the same result. I'm almost sure it has to do with the size of the table, because before I was working with a temp APTH that contained a small portion of the whole data set and it had sorted fine. But after I had imported all of the data it won't filter it at all.
@mdevaney Any ideas? I don't have an entity with 400k records to test anything out.
@mdevaney @SeanHenderson dang, well thank you for the help cleaning up my logic a little bit. Maybe splitting the entity up into multiple entities, then create collections for each entity, filter each, then combine them in the same screen? Not even sure if this is possible.
@sandeepdknow of any work arounds?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 366 Most Valuable Professional
11manish 184
MS.Ragavendar 99 Super User 2026 Season 1
