PowerApps Cascading Dropdown

Introduction

 

In this article, we will see how to implement a cascading dropdown in PowerApps and save it back to the SharePoint list.

 

We will create an example for employee information and we will have two dropdowns: country and state. We want to filter state dropdown based on the country dropdown selection. Let's start with step-by-step implementation.

 

Demo

 

Create SharePoint lists as below:

• Create a list called Country with the below field:

 

• Create a list called State with the below fields:

•  Set the Country Lookup column as shown below:

• Create a list called Employees with the below fields:

 

• Set the Country Lookup as created above in State List.

• Set the State Lookup as below:

 

Let's start the PowerApps Implementation step by step:

• Move to the PowerApps
• Go to the Create > Canvas app from blank
• Give App name and select format

 Now we will add the required controls (Labels, Dropdowns, and button) in our PowerApps as shown below:

 

 

Add the required Data sources as below:

• Go to the View on top ribbon > Select Data source > Search SharePoint > Add connection > Connect to the SharePoint Site > Select lists (Country ,State and Employees).

Map data source with Dropdowns:

• Select Country Dropdown - Set Items Property as shown below:

• Select State Dropdown - Set Items Property as shown below:
  
  

Now we will save the record in SharePoint list as shown below.

 

Select the Submit button - Set OnSelect Property as shown below:

Patch(
    Employees,
    Defaults(Employees),
    {
        Title: "test",
        Country: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
            Id: ddCountry.Selected.ID,
            Value: ddCountry.Selected.Title
        },
        State: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
            Id: ddState.Selected.ID,
            Value: ddState.Selected.Name
        }
    }
);
Notify("Record Saved Successfully!!!");

Refer to this article to learn how to use the Patch function in PowerApps.

 

Output

 

 

Summary

 

In this article, we have seen how to create a cascading dropdown in PowerApps with a demo application. 

 

I hope you like this article, share it with others. Give your valuable feedback and suggestions in the comments section below. 

 

Sharing is caring!!!