Distinct() not bringing all values

(0) Share

Report

Posted on by HectorOlivos

411

Hello Community!

I have a problem with the Distinct function. I've a combobox linked to a SQL Database. In that combobox I can search for an specific DMC. The column that has all the DMC´s is named 'DMC', there are more than 500 Different DMC´s, but it goes up to 8350 because some are repeated. When i try to use distinct: Distinct(Database,DMC). It's only bringing 25 item.

This combobox populates a gallery:

Items: SortByColumns(
 Filter(
 Database,
 cmb_DMC.Selected.Value = DMC
 ),
 "ID_Orden",SortOrder.Ascending)

How can I bring all the DMC´s without being repeated?

Thanks,

Hector O.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

HectorOlivos 411 on at

Like (0)

Report
Copy link

Link copied!

I'm just going to use a text input since is way easier!

Was this reply helpful? Yes No