How to Display Combo Box Items from SharePoint list in Power Apps?

I was just given a Power Apps requirement to display items from a SharePoint list in a Combo box. In addition, I also needed to show how to retrieve SharePoint multiple-column values in a Power Apps Combo box control.

However, I did a great job of achieving this in a simple, tricky way. In this article, I will explain to you how to display combo box items from SharePoint list in Power Apps.

Also, we will discuss how to display the combo box items from the SharePoint list person column and many more like:

  1. Show Power Apps combo box items from the SharePoint list based on condition.
  2. How to Display Multiple Columns in Power Apps Combo Box

How to Display Combo Box Items from SharePoint list in Power Apps

Let’s check how to display the combo items from the SharePoint list in different scenarios like:

Example – 1: [Power Apps Combo box items from SharePoint Text Column]

Here, you will learn how to bind the Power Apps combo box items from the SharePoint list text field.

I have a SharePoint list [Customer Details] that has two columns like:

Column NameData Type
User NameTitle
CountrySingle line of text

Refer to the image below.

Power Apps Combo box with SharePoint list

Here, I want to bind the list of countries to a Power Apps combo box control. Whenever the user expands the combo box, it shows the values from the respective SharePoint list country column.

Power Apps Combo box SharePoint list

To achieve this, follow the below steps:

  • Sign in to your Power Apps with your valid Microsoft 365 credentials.
  • Create a Blank canvas app -> On the Power Apps screen, insert a Combo box control [Click on +Insert -> Expand Input -> Select Combo box]
Power Apps Combo box items from the SharePoint list
  • Set the combo box Items property to:
'Customer Details'.Country

Where,

  1. Customer Details = SharePoint list name
  2. Country = SharePoint list column name
Combo box items from the SharePoint list in Power Apps
  • SavePublish, and Preview the app. Now, the combo box control contains the items from a SharePoint list column, as shown below:
Power Apps Combo box items from SharePoint list column

This is how to bind the Power Apps combo box items from the SharePoint list text column.

Example – 2: [Display Power Apps Combo box items from SharePoint Person Column]

Let us see how to display the combo box items from the SharePoint person column.

I have a SharePoint list [ACGH Project Details], that has a person/group column as “Manager/Team Lead.”

On the Power Apps screen, I have a Combo box control, that needs to display a list of users stored in a SharePoint List under a ‘People or Group‘ field, as shown below:

Combo box users from SharePoint List in Power Apps

Follow the below steps to achieve this:

  • On the Power Apps screen, insert a Combo box control -> Set its Items property to:
Distinct(
    'ACGH Project Details',
    'Manger/ Team Lead'.DisplayName
)

Where,

  1. ACGH Project Details = SharePoint list name
  2. Manger/ Team Lead = SharePoint list person column name
Display combo box items from SharePoint list
  • SavePublish, and Preview the app. Now, the combo box control contains the items from a SharePoint list person column, as shown below:
How to display Power Apps combo box users from SharePoint List

This is how to bind the Power Apps combo box items from SharePoint list person column.

Example – 3: [Display Power Apps Combo box items from SharePoint list based on condition]

Let’s check how to display the combo box items from the SharePoint list based on certain conditions.

I have a SharePoint list [ACGH Project Details] that has two columns:

  1. Project Name [Single line of text]
  2. Project Status [Choice – “In-progress,” “Not-Started,” “Completed”]
Display Power Apps combo box items from the SharePoint list based on condition

On the Power Apps screen, there is a Combo box control where I want to display the items as ‘Project Names’ that have an “In-progress” status, as shown below:

Populate Combo box choices with filtered list from SharePoint

To achieve it, follow the below steps:

  • On the Power Apps screen, insert a Combo box control -> Set its Items property to:
Filter(
    'ACGH Project Details',
    'Project Status'.Value = "In-progress"
).'Project Name'

Where,

  1. ACGH Project Details = SharePoint list name
  2. Project Status = SharePoint list choice column name
Combo Box items from SharePoint list in Power Apps
  • SavePublish, and Preview the app. Now, the combo box control contains the items as ‘Project Names’ that have an “In-progress” status using a SharePoint list.
Power Apps combo box items from SharePoint list based on condition

This is how to display the combo box items from the SharePoint list based on certain conditions.

Example – 4: [How to Display SharePoint Multiple Columns in Power Apps Combo box]

Here, you will learn how to display the combo box items using SharePoint multi-column values.

On the Power Apps screen, I have added Combo box control. However, I want to display the combo box items with two columns sourced from the above SharePoint list [Project Name and Project Status.]

How to Display Multiple Columns in Power Apps Combo box

Follow the below steps to achieve this:

  • On the Power Apps screen, insert a Combo box control -> Set its Items property to:
SortByColumns(
    AddColumns(
        'ACGH Project Details',
        "BOTHNAMES",
        Concatenate(
            'Project Name',
            "  ",
            " [",
            'Project Status'.Value,
            "]"
        )
    ),
    "BOTHNAMES",
    SortOrder.Descending
)

Where,

  1. ACGH Project Details = SharePoint list name
  2. Project Name = SharePoint list column name
  3. Project Status = SharePoint list choice column name
Display Multiple Columns in Power Apps Combo box
  • SavePublish, and Preview the app. Now, the combo box control contains the items from the multiple columns using the above SharePoint list [Project Name and Project Status]
Power Apps display Multiple Columns in Combo box

Conclusion

I trust this Power Apps tutorial provided a complete understanding of binding combo box items using a SharePoint list.

Throughout this tutorial, I have shown various scenarios where you can display combo box items using a SharePoint list, such as:

  1. Power Apps combo box items from the SharePoint list
  2. Power Apps combo box users from the SharePoint list
  3. Display Power Apps combo box items from the SharePoint list based on condition
  4. How to Display Multiple Columns in Power Apps Combo Box

Also, you may like some more Power Apps tutorials: