Answered

Using Distinct on Azure SQL

(0) Share

Report

Posted on by dansshin

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.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

Meneghino 6,949 on at

Like
a
(2)

Report
Copy link

Link copied!

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.
dansshin 53 on at

Like
a
(0)

Report
Copy link

Link copied!

@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 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

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/23193

You can create one on Dstinct, of course.

Search is here:
https://powerusers.microsoft.com/t5/forums/searchpage
dansshin 53 on at

Like
a
(1)

Report
Copy link

Link copied!

I added Distinct.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Please-Extend-delegation-to-Distinct/idi-p/23207#M1426

Thank you.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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