SHOW IN A COMBOBOX MY CHOICES COLUMN IN COLLECTION (DATA)

[Gorilla_8]

I wanna show in my combobox my choices column saved on PowerApps Collection, I can't use distinct.

I tried: 

Choices(Collection.NameColumn)

Choices(Collection;NameColumn)

[C-Papa]

Assuming you have the choices tied to a column in Sharepoint / Dataverse you should be able to use the below

Choices([@'DatabaseName'].ColumnName)

[Gorilla_8]

@C-Papa 

Thanks, but my DataSource have more then 100 k items

[C-Papa]

That should be fine as long as the choices are defined in the column within your data source, what is you data source? why cant you use distinct? If you have to use a collection the distinct function you be the only way to get the unique values. Remember, powerapps has a maximum record capacity in 1 query of 2000 rows / items. you wont be able to show 100k of choices in one collection without some complex work arounds

[Gorilla_8]

@C-Papa 

My DataSource is SharePoint and I have index column, in my column that I need, but didn't work, so I make a collection to get all the data, it's work, but I wanna show my choice in this combobox

[C-Papa]

Why don't you want to use distinct? this should work

Distinct(CollectionName, ColumnName)

if the column is a choice column then you would need to use

Distinct(CollectionName, ColumnName.Value)

[Gorilla_8]

I cant because there repeting value I need to show

Here my error: 

[C-Papa · Accepted solution]

That error suggests you need to index the columns within SharePoint, the below link should help

Add an index to a list or library column (microsoft.com)

in response to showing all of the records in the column in a combobox, you can use the following in the items property:

ListVendas.CUSTOMER

[Gorilla_8]

@C-Papa 

Thanks for the link, I already did this, but I  didn't understanding very well

And the solution ListVendas.CUSTOMER works perfectly, thank you!