cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dansshin
Advocate IV
Advocate IV

Using Distinct on Azure SQL

Hi,

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino
Community Champion
Community Champion

Hi @dansshin, Distinct is not yet a delegable function, that is the issue.

It will look at the first 500 rows only.

We need to wait for delegation to be extended, this is a most urgent issue so please add your vote to related issues in the ideas.

Thanks.

View solution in original post

6 REPLIES 6
v-monli-msft
Community Support
Community Support

Hi dan,

 

I have reported your issue to the PowerApps team, I will get back once I got any update about this issue.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Meneghino
Community Champion
Community Champion

Hi @dansshin, Distinct is not yet a delegable function, that is the issue.

It will look at the first 500 rows only.

We need to wait for delegation to be extended, this is a most urgent issue so please add your vote to related issues in the ideas.

Thanks.

View solution in original post

@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?

 

Thank you.

Meneghino
Community Champion
Community Champion

There is nothing yet specifically for Distinct, but here is a related one:

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Extend-delegation-to-IsBlank/idi-p/13914

 

And I have just created this one too:

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Extend-delegation-to-Sum-and-CountRows/idi-p/231...

 

You can create one on Dstinct, of course.

 

Search is here:

https://powerusers.microsoft.com/t5/forums/searchpage

Anonymous
Not applicable

Is there any workaround distinct? I am using search however do not know how te remove duplicates?

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,602)