I have below query that doesn't seem to be getting all the distinct values in my table column. Table has 200k rows and it looks like it's only looking at less than first 1000 rows. Anyone know how to get it to query all the records to return the distinct values?
SortByColumns(Search(Distinct('[dbo].[WFGSP_SeedPlan]', DSM), DSMSearchBox.Text, "Result"), "Result", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
Thanks for any feedback in advance.
Solved! Go to Solution.
I have reported your issue to the PowerApps team, I will get back once I got any update about this issue.
@Meneghino Thank you for the confirmation.
I suspected it as much so I modified the data model so I didn't have to use the Distinct and updated the code and now it's working with 200k+ rows. I'll make sure to add my vote to related issue for this.
It looks like there is no search within Ideas forum. Do you happened to have link to the related posted for this in there?
There is nothing yet specifically for Distinct, but here is a related one:
And I have just created this one too:
You can create one on Dstinct, of course.
Search is here:
I added Distinct.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.