Whenever working with the Power Apps dropdown control, some of the SharePoint list columns might not be supported by this control. Such as:
- Date and Time
- Person or group
- Yes/no, etc…
To overcome this, I will explain some of the tricks and steps to help you retrieve all the SharePoint column values in the Power Apps dropdown.
Power Apps Dropdown Values Not Showing [From SharePoint List]
First, I will show you how to retrieve the SharePoint list choice field values in the Power Apps dropdown control.
1. I have a SharePoint Online list, i.e., [Project Tracker]. This list contains the below fields.
|Column Name||Data Type|
|Project Name||It is a default single line of text, I just renamed it as “Project Name”|
|Description||Multi lines of text|
|Start Date||Date and time|
|End Date||Date and time|
2. In Power Apps, there are two Dropdown controls and I have used the below code in the Power Apps Dropdown’s Items property to retrieve the SharePoint column values in the Power Apps dropdown.
Items = 'Project Tracker'.Title // For Text Field Values Items = 'Project Tracker'.ProjectStatus // For Choice Field Values
- ‘Project Tracker’ = SharePoint Online List
- Title, ProjectStatus = SharePoint List Columns
3. Here, the first dropdown displays the SharePoint list text values; in the second dropdown, I tried to display the SharePoint choice field. However, as shown below, it will not retrieve the choice field values.
4. Also, I was facing a Delegation warning “The columns produced by this rule are all nested tables/or records. However, the property expects at least some columns of simple values (such as text/or numbers)”.
5. This delegation warning clearly says that the dropdown control will only accept the Text/Number columns instead of all the remaining columns.
6. To resolve this, I added the code below in the Power Apps Dropdown’s Items property. Then, it will display all the SharePoint choice field columns like below.
Items = Choices([@'Project Tracker'].ProjectStatus)
This is how to display the SharePoint choice field values in the Power Apps dropdown control.
Power Apps Dropdown is Not Working in the SharePoint Edit Form
Next, we will see why the Power Apps dropdown is not working in the SharePoint edit form and how to overcome this by following the example below.
1. I will also take the same SharePoint Online list [Project Tracker] for this example.
2. In Power Apps, I have a Power Apps edit form that connects to the SharePoint list. Whenever you connect the SharePoint list to the Power Apps edit form, you will see the SharePoint choice field displayed on the Combo Box control.
3. But, it is not the right way to display the SharePoint choice field. The SharePoint choice field values should be displayed on the Power Apps dropdown control.
Refer to the below image:
To work around this example, follow the below steps. Such as:
4. On the Power Apps Screen -> Insert an Edit form [frm_Projects] and set its DataSource as:
DataSource = 'Project Tracker'
5. To display the SharePoint list fields in the form control, click the Edit fields option and add fields as needed.
6. To get the Edit Form to a New form, just set the Default mode as “New” as in the screenshot below.
7. Select Combo Box control -> Copy the DataCardValue & Items property -> Remove the combo box control.
DatacardValue = DataCardValue3 Items = Choices([@'Project Tracker'].ProjectStatus)
- DataCardValue3 = Combo Box Control DataCardValue
- Choices([@’Project Tracker’].ProjectStatus) = SharePoint List Choice Field
8. Now, insert the Dropdown control in the ProjectStatus_DataCard -> Set its DataCardValue and Items property to replace the position of the combo box control.
DataCardValue = DataCardValue3 Items = Choices([@'Project Tracker'].ProjectStatus)
9. Save, Publish, and Preview the app. The dropdown control will display each record from the SharePoint list choice field, as in the screenshot below.
This is how to display the SharePoint choice field values in the Power Apps dropdown using the edit form.
Power Apps DropDown Control Value Limit
While working with Power Apps dropdown control, there is a certain limitation of items [Maximum 500 Items] displayed on the dropdown. Also, you can change this to 2000 from the Data row limit under the Settings.
For further information, follow this complete tutorial: Power Apps DropDown Control Value Limit
This Power Apps tutorial taught in detail information about the Power Apps dropdown values not showing in different cases. Such as:
- Power Apps dropdown not showing values from a SharePoint choice field
- Power Apps dropdown control is not working in the SharePoint edit form
- Working with Power Apps dropdown value limit
Also, we discussed some of the tricks and steps that will help to retrieve all the SharePoint column values in the Power Apps dropdown.
Moreover, you may like some more Power Apps tutorials:
- Bind SharePoint Lookup Column in Power Apps Dropdown
- Display Column Names in Power Apps Dropdown
- Display Multiple Columns in Power Apps Dropdown
- How to Validate Power Apps Dropdown Control
- Bind Power Apps Dropdown Items From Collection
- Display SharePoint Person Column in Power Apps Dropdown
Bijay Kumar Sahoo is a highly accomplished professional with over 15 years of experience in the field of SharePoint and related technologies. He has been recognized as a Microsoft MVP (Most Valuable Professional) more than 9 times, starting from April 2014, for his exceptional contributions to the SharePoint community. Bijay is also a prolific author, having written two books on SharePoint – “Microsoft Power Platform – A Deep Dive” and “SharePoint Online Modern Experience Practical Guide“. His deep insights into SharePoint are also shared on his popular YouTube channel EnjoySharePoint where he teaches SharePoint to a global audience (From various countries like the United States of America, Canada, the United Kingdom, Australia, New Zealand, etc). Read more…