Dropdown Sharepoint Column

(0) Share

Report

Posted on by seadude

1,855

Why am I having so much trouble with this (probably because its late).

Scenario:

Sharepoint list with a column named "crew_num"
Dropdown control in PowerApp
I want every crew_num to be an option in the dropdown

Why can't I just set the Dropdown Items property to listName.crew_num and call it good? I've tried Distinct(listName,crew_num) and like 4 variants of Sort(Filter(Distinct))). I cannot figure out how to simply show an entire Sharepoint list column in a dropdown. Time for bed!

Anyone have a simple way to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

dinusc Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

You're very close. If your column is of type "Number" then just simply set the DropDown.Items to the list name and then select the column (crew._num) from the "Value" dropdown on the right (see the screenshot below).

If however the column type is "Choices" then use the following formula:
DropDown1.Items=Choices(listName.crew_num)

Was this reply helpful? Yes No
seadude 1,855 on at

Like
a
(0)

Report
Copy link

Link copied!
I had made a few changes to the Sharepoint list crew_num column and the results were not as expected (in a list of 5 crew_nums only the first one was showing up 5x in the dropdown.).

Refreshed data
Same issue
Removed data sources
Reconnected data sources
Now all 5 options show in the dropdown.
Thanks for the help! I really appreciate it.

Was this reply helpful? Yes No