Power Apps Dropdown Values Not Showing [How to Overcome]

by
Power Apps Dropdown All Values Not Showing From SharePoint

Whenever working with the Power Apps dropdown control, some of the SharePoint list columns might not be supported by this control. Such as:

  • Choice
  • Date and Time
  • Currency
  • 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.

Example:

1. I have a SharePoint Online list, i.e., [Project Tracker]. This list contains the below fields.

Column NameData Type
Project NameIt is a default single line of text, I just renamed it as “Project Name”
DescriptionMulti lines of text
Project StatusChoice
Start DateDate and time
End DateDate and time
Power Apps Dropdown Values Not Showing

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

Where,

  • ‘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.

Power Apps Dropdown All Values Not Showing

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.

Power Apps Dropdown All Values Not Showing From SharePoint

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)
Power Apps Dropdown All Values Not Showing From SharePoint List

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.

Example:

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.

Power Apps Dropdown is Not Working in SharePoint Edit Form

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:

Power Apps dropdown is not work in SharePoint edit form

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.

Power Apps dropdown is not work in SharePoint list edit form

7. Select Combo Box control -> Copy the DataCardValue & Items property -> Remove the combo box control.

DatacardValue = DataCardValue3

Items = Choices([@'Project Tracker'].ProjectStatus)

Where,

  • DataCardValue3 = Combo Box Control DataCardValue
  • Choices([@’Project Tracker’].ProjectStatus) = SharePoint List Choice Field
Power Apps dropdown is not work using SharePoint edit form

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)
Power Apps dropdown is not work using the SharePoint edit form

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.

Power Apps dropdown is not work using SharePoint Online edit form

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

Conclusion

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: