cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rhossian
Frequent Visitor

Getting a column choices from SharePoint list to show on PowerApps

Hi, 

 

I have a combo box which is trying to get the data from the SharePoint list.  I could hardcode the values to the combo box but i want it update dynamically. How do I go about getting those choices from SharePoint to show up on my combo box in PowerApps. I have included the combo box screenshot as well as the screenshot for the choices column from the SharePoint list. 

 

Thank you all for the help in advance. 

 

sharepoint column.PNGstatus.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
rhossian
Frequent Visitor

I figured it out. Items = Choices([@'Name of the database'].'Incident Status')

View solution in original post

2 REPLIES 2
rhossian
Frequent Visitor

I figured it out. Items = Choices([@'Name of the database'].'Incident Status')

View solution in original post

Hi @rhossian

Thanks for your sharing. Glad that you have solved your problem. 

You are right that the Choice() function could be used to pull out all the options from the Choice column within the SP list.

Generally, we use the following formula to set for the Items of the dropdown control.

Choices(DataSource.ChoiceColumnName)

Congratulations for you agian.

Please mark the solution as an answer so that other users who have the similar issues could find it easily.

 

Best Regards,
Qi

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,349)