cancel
Showing results for 
Search instead for 
Did you mean: 

Please Extend delegation to Distinct

Hi,

 

I noticed that Distinct using Azure SQL isn't fully supported as it seems to be limited to 500 or 1000 rows. Could you please extend delegation to Distinct function so it can be used with whole dataset?

 

Thank you.

Status: Under Review
Comments
Power Automate Staff
Status changed to: Under Review
 
Level: Powered On

I wanted to find out if this had been done yet. It would be great to have distinct be delegable

Level 8

Why do we need this? In my use case I have a large SharePoint list and I only need one column, to populate a dropdown field. Because SharePoint isn't relational, the column I want has duplicates - basically, it's a list of 'systems', and each system can have many 'applications', but all I want is the systems.

 

Since there are some 350 applications, and I only need the list of 30 systems, it's grossly inefficient for me to bring back all 300+ rows for 30 items.

RS
Level: Powered On

It's been 8 months. Any update? This wall of silence on the status pf so many key features is not helpful.

gog
Level: Powered On

Any ETA??

Level: Powered On

I am also in this situation where I have a list over 500 records long and I want to pull back all Distinct values in the Category field but it doesn't return all of them.  This is a required design feature and I cannot release an App if it doesn't work properly.

Level: Powered On

I am also in need of this. For now, I am going to create a view in my database that lists the unique values from my main datasource that will go in my combobox. At least it is good to know that I was not using the Distinct wrong or something was corrupted with my datasource (for some reason PowerApps is only pulling the first 100 rows instead of the default 500).

Level: Powered On

Any update on distinct delegation?

Level: Powered On

Still no update. I really need it too.

Level: Powered On

Any update please ?