cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gorilla_8
Impactful Individual
Impactful Individual

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

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)

 

1 ACCEPTED SOLUTION

Accepted Solutions
C-Papa
Super User
Super User

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

 

 

 

View solution in original post

8 REPLIES 8
C-Papa
Super User
Super User

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
Impactful Individual
Impactful Individual

@C-Papa 

 

Thanks, but my DataSource have more then 100 k items

C-Papa
Super User
Super User

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
Impactful Individual
Impactful Individual

@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
Super User
Super User

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
Impactful Individual
Impactful Individual

I cant because there repeting value I need to show

 

Here my error: 

Gorilla_8_0-1634748829670.png

 

C-Papa
Super User
Super User

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

 

 

 

View solution in original post

Gorilla_8
Impactful Individual
Impactful Individual

@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!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,319)