DISTINCT Function in PowerApps

(0) Share

Report

Posted on by manjotsingh057

164

I have a on premise SQL table where we have 16000 records.

There is a column Named "ApplicationType".

We want to populate a dropdown in PowerApps with unique Application Type values that are there in that table.

So i used below query to fetch distinct Application Type values.

Distinct('[dbo].[SpecialProjects]',ApplicationType);

Issue :

Since PowerApp fetches 200 records at one time so this formula retrieves distinct values only for those 200 records.

This way i get only 1 unique ApplicationType values out of 3.

Any way by which we can get all distinct values of a column from SQL table?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

timl 37,262 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @manjotsingh057

The way to do this is to create a SQL Server View that returns your distinct values.

https://powerusers.microsoft.com/t5/General-Discussion/Retrieve-distinct-values-over-a-column-from-SQL-Server-data/td-p/171409

Post back here if you need more specific details on how to do this.

Was this reply helpful? Yes No
manjotsingh057 164 on at

Like
a
(0)

Report
Copy link

Link copied!
@timl
Thanks for that post.
But if i want to create a cascaded drop downs, Will that be possible based on this logic ? Since i will not be knowing what all values would be there in next set of results that would be Loaded by PowerApps ?

Scenerio:
Page has multiple drop down fields which filter the results.
You select value from drop down 1 and based on the results received drop down 2 values should be filtered as well.
Once you select drop down 2 values then again following same logic.

Thanks in Advance !!

Was this reply helpful? Yes No
Verified answer

timl 37,262 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @manjotsingh057

Yes, it's possible to build cascading drop downs with SQL Views.

My post towards the end of this thread includes some sample formula.

https://powerusers.microsoft.com/t5/General-Discussion/Slice-Large-SQL-Table-By-Multiple-Parameters/td-p/176328/page/2

Was this reply helpful? Yes No
manjotsingh057 164 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot @timl
That works.

Was this reply helpful? Yes No