web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Use combo box to show ...

Power Apps

Unanswered

Use combo box to show all values in a column

(0) Share

Report

Report

Posted on by abyars

I have a list of items in a SQL column called "Item":

and I would like to be able to show each item as its own option in a combo box. I would like for it to look like this without having to hard-code:

Any help would be awesome!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Ali_Sheraz_77 141 on at

Like (0)

Report
Hi, @abyars
[
Use this code on items property of ComboBox

Choices([@'16. Order Management'].'User Account')

adjust code according to your SP List
'User Account'= column name
[@'16. Order Management']=SharePoint list name
]

Please give a thumbs up if this information is helpful.
Best regards,
Ali Sheraz

Was this reply helpful? Yes No
abyars on at

Like (0)

Report

I do not have a choice column, I have a text column with one field per row. I would like to list every row in a combo box.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @abyars,

To list every row of the Item column in your ComboBox, just set Items property:

Table.Item

To populate the ComboBox with a column from SQL table, using Distinct() to get distinct items, you just need to set the ComboBox Items property as:

Distinct(Table,Item)

Was this reply helpful? Yes No

Join the conversation