cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Dropdown Sharepoint Column

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft dinusc
Microsoft

Re: Dropdown Sharepoint Column

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).Capture.PNG

 

 

If however the column type is "Choices" then use the following formula:

DropDown1.Items=Choices(listName.crew_num)

View solution in original post

2 REPLIES 2
Microsoft dinusc
Microsoft

Re: Dropdown Sharepoint Column

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).Capture.PNG

 

 

If however the column type is "Choices" then use the following formula:

DropDown1.Items=Choices(listName.crew_num)

View solution in original post

Super User
Super User

Re: Dropdown Sharepoint Column

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.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (6,346)