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
Highlighted
Microsoft
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
Highlighted
Microsoft
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

Highlighted
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,996)