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 (Last 30 Days)
Users online (5,346)