How to Create Power Apps Cascading Dropdown From SharePoint List?

Are you familiar with the cascading dropdown control in Microsoft Power Apps? If not, this tutorial will help you understand everything related to the Power Apps cascading dropdown.

In this article, I will show you how to create Power Apps cascading dropdown from SharePoint list. Moreover, we will cover the following topics:

  • Power Apps cascading dropdown for SharePoint Lookup column.
  • Power Apps Cascading dropdown for SharePoint Person field.

What is Power Apps Cascading Dropdown?

In Power Apps, the Cascading dropdown means the value of the second dropdown control depends on the first dropdown selected value.

For Example,

  1. When a user selects a value from the first dropdown. Then, values in the second dropdown change automatically based on the selection made from the first dropdown.

Following the steps below, you can implement a cascading dropdown in Power Apps.

How to Create Power Apps Cascading Dropdown From SharePoint List

Let’s see how to create a cascading dropdown in Power Apps:

For Example, I have a SharePoint Online list [Product list] that has various columns like:

Column NameData Type
Product IDTitle
ProductChoice [“Laptop,” “Mouse,” “Head Phone,” “Smart Phone,” “Xbox Series S -1TB”]
VendorLookup
Product Order DateDate and time
Product Handled ByPerson or group
Create a Power Apps cascading dropdown

I created a Power Apps Canvas app and added an Edit form connected to the above SharePoint list. The edit form contains two Dropdown controls. The first dropdown control contains all the values from the “Vendor” lookup column.

The other dropdown contains all the values from the choice column named “Product.” Upon selecting a value from the “Vendor” Dropdown control, the values in the “Product” Dropdown control will adjust automatically based on the selected value from the first Dropdown, as shown below:

How to create a Power Apps cascading dropdown

Let me show you how to achieve this:

  • Open Power Apps, create a Blank canvas app, -> Connect the SharePoint list to the app.
Cascading dropdown in Power Apps
  • Insert a first Dropdown control -> Set its Items property to:
Choices('Product List'.Vendor)

Where,

  • Product list = SharePoint list name
  • Vendor = SharePoint list lookup column name
Power Apps cascading dropdown control
  • The value for this dropdown should be based on the selection from the previous dropdown; for that, insert an additional Dropdown control -> Set its Items property to:
Distinct(
    Filter(
        'Product List',
        'Vendor'.Value = drp_Vendor.Selected.Value
    ).Product,
    Product.Value
)

Where,

  • Product list = SharePoint list name
  • Product = SharePoint list choice column name
  • drp_Product = Combo box control name
  • Vendor = SharePoint list lookup column name
Cascading dropdown Power Apps
  • Once your app is ready, Save, Publish, and Preview the app whenever the user selects a value from the first dropdown. Then, the second dropdown values will change automatically, as shown below:
How to create a cascading dropdown in Power Apps

This is how we can create a cascading dropdown in Power Apps.

Power Apps cascading dropdown SharePoint lookup column

This section will explain how to create a Power Apps cascading dropdown using the SharePoint list lookup column.

Example,

I have two SharePoint lists, namely:

  1. Meetings [Parent Table]
  2. Meeting Scheduled [Child Table]

Meetings [Parent Table]

This SharePoint list has various columns like:

Column NameData Type
Meeting TypeTitle
DescriptionMultiple lines of text
How to create Power Apps cascading dropdown SharePoint lookup column

Meeting Scheduled [Child Table]

This SharePoint list has various columns like:

Column NameData Type
Meeting TitleTitle
Meeting TypeLookup [The column retrieved from Parent Table “Meeting Type”]
Meeting Scheduled DateDate and time
Power Apps cascading dropdown SharePoint lookup column

I created a Power Apps Canvas app and added two Dropdown and Gallery controls. The first dropdown control contains all the values from the above parent SharePoint list title [Meeting Type] column.

The second dropdown contains all the values from the “Meeting Title” column of the above child SharePoint list.

When a user selects a value from the Meeting Type dropdown control, the values in the Scheduled Meeting dropdown control values will change automatically.

Eventually, upon selecting a value from the second dropdown, the gallery filters according to both dropdown values and ultimately displays the respective meeting’s date and time, as shown below:

Power Apps cascading dropdown SharePoint online lookup column

Let’s see how to achieve it:

  • On the Power Apps screen, insert a first Dropdown control -> Set its Items property to:
Distinct (Meetings, Title)

Where,

  • Meetings = SharePoint list name
  • Title = SharePoint list title column
How to create Power Apps cascading dropdown using SharePoint lookup column
  • Under the first dropdown control, insert another Dropdown control -> Set its Items property as:
Filter(
    'Meeting Scheduled',
    'Meeting Type'.Value = drp1_MeetingType.Selected.Value
).Title

Where,

  1. Meeting Scheduled = Child SharePoint list name
  2. Meeting Type = Child SharePoint list lookup column name
  3. drp1_MeetingType = First dropdown control name
  4. Title = Child SharePoint list title column
Create Power Apps cascading dropdown using SharePoint lookup column
  • Insert a Calendar blank icon, and then insert a Gallery control onto the same icon as shown below:
Cascading dropdown in SharePoint list using Power Apps
  • Set the gallery control, Items property to:
Filter(
    'Meeting Scheduled',
    'Meeting Type'.Value = drp1_MeetingType.Selected.Value && Title = drp2_SheduledMeeting.Selected.Title
)

Where,

  1. Meeting Scheduled = Child SharePoint list name
  2. Meeting Type = Child SharePoint list lookup column name
  3. drp1_MeetingType = First dropdown control name
  4. Title = Child SharePoint list title column
  5. drp2_SheduledMeeting = Second dropdown control name
Power Apps cascading dropdown SharePoint lookup
  • On the gallery property pane, change the layout style to Title -> Click on Edit fields -> Then choose the Meeting Scheduled date column as shown below:
How to create Power Apps cascading dropdown SharePoint lookup
  • Save, Publish, and Preview the app. Select a specific item from the first dropdown [One-on-one meeting], and select “Meeting with Daniel” from another dropdown.
  • At the same time, the gallery will filter and display the date and time of a one-on-one meeting scheduled with Daniel.
Power Apps cascading dropdown using SharePoint lookup

This is how I created a Power Apps cascading dropdown using the SharePoint list lookup column.

Cascading Dropdown for SharePoint List Person field in Power Apps

Here, we can see how to create a cascading dropdown for SharePoint list person filed in Power Apps.

Example:

I have a SharePoint list [Product Issue Tracker] that has various columns like:

Column NameData Type
Issue IDTitle
Issue TypeChoice [“Laptop,” “HeadPhone,” “IT Issues”]
Issue Assigned ToPerson/group
Is Still Issue Is ActiveYes/no
Cascading dropdown for SharePoint list person field in Power Apps

The Power Apps screen has two Dropdown controls and a Gallery control. The first dropdown control contains all the values from a “SharePoint list choice column.” Another dropdown contains all the values from a “SharePoint list person column.”

When a user selects any value from the Issue Type dropdown control, then Issue Assigned To dropdown control values will change automatically by displaying the user’s name. Later, the gallery will filter and display all the relevant records based on both dropdown-selected values.

How to create a cascading dropdown for SharePoint list person field in Power Apps

Let’s see how to achieve this:

  • Insert a Dropdown control on the Power Apps screen -> Set its Items property to:
Distinct('Product Issue Tracker','Issue Type'.Value)

Where,

  1. Product Issue Tracker = SharePoint List Name
  2. Issue Type = SharePoint List Choice Column
Power Apps dropdown items from the SharePoint list person column
  • Under the first dropdown control, insert another dropdown control -> Set its Items property to:
Distinct(
    Filter(
        'Product Issue Tracker',
        'Issue Type'.Value = drp_IssueType.Selected.Value
    ).'Issue Assigned To',
    'Issue Assigned To'.DisplayName
)

Where,

  1. Product Issue Tracker = SharePoint List Name
  2. Issue Type = SharePoint List Choice Column Name
  3. drp_IssueType = First Dropdown Control Name
  4. Issue Assigned To = SharePoint List Person Column
How to use Power Apps dropdown items from SharePoint Online list person column
  • Once we Save and Preview the app, we can see that the second dropdown control value depends upon the first dropdown control value.
How to create Power Apps dropdown items from SharePoint Online list person column
  • Insert a Vertical gallery control -> Set its Items property to:
Filter(
    'Product Issue Tracker',
    'Issue Type'.Value = drp_IssueType.Selected.Value && 'Issue Assigned To'.DisplayName = drp_IssueAssignedTo.Selected.Value
)

Where,

  1. Product Issue Tracker = SharePoint List Name
  2. Issue Type = SharePoint List Choice Column Name
  3. drp_IssueType = First Dropdown Control Name
  4. Issue Assigned To = SharePoint List Person Column
  5. drp_IssueAssignedTo = Another Dropdown Control Name
How to add Power Apps dropdown items from SharePoint list person column
  • Save, Publish, and Preview the app. Select a specific item from the dropdown [Laptop], and select “Lidia Hollaway” from another dropdown. Now, the gallery will filter and display all the laptop issues handed by Lidia Hollaway.
Display Power Apps dropdown items from SharePoint list person column

This is how we can create a cascading dropdown for SharePoint list person filed in Power Apps.

Conclusion

I hope this tutorial has helped you understand the Power Apps cascading dropdown and how to create a cascading dropdown in Power Apps.

Furthermore, I have explained how to work with the Power Apps cascading dropdown using SharePoint list as a data source, including the lookup values.

Lastly, I have shown you the cascading dropdown in Power Apps for the SharePoint List Person fields.

Also, you may like some more Power Apps tutorials: