cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
seadude
Level 10

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 Employee

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 Employee

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

seadude
Level 10

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 Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 102 members 5,129 guests
Please welcome our newest community members: