Implement multilevel cascading dropdown in Power Apps from SharePoint

Implement multilevel cascading dropdown in Power Apps from SharePoint

Power Apps is a low-code platform used to built custom applications that can work across all devices whether mobile, tablet, laptop or desktop. The drag and drop functionality, ease of customization, full control on labels, and seamless integration with more than 200+ connectors makes Power Apps a preferred choice amongst developers. However, implementing some functionality within Power App can sometimes be challenging. In this article we will be discussing about one of the challenges of implementing multilevel cascading dropdown in Power Apps from SharePoint.

Through this post, we will learn how to implement multilevel cascading dropdown in Power Apps with no steps skipped.  

Create List from the SharePoint

  • From the SharePoint create two new list and name them “Data List” and “Main List”.
  • Populate the Main List with items of Region, Country and State.

Create an app

  • Login with your credentials in Power Apps Studio to create an app and select the layout of your choice in blank app.

Connect to data sources

  • In the top navigation bar select View tab and click on data sources. Connect your app with Main List and Data List.

Create a form

  • Now select Insert tab from the top navigation bar and select Forms from the ribbon.
  • In the right-hand side under properties, select Data List in Data source
  • After the data source is connected the form will be displayed on the screen with Title, Region, Country, State and Attachments fields like below.
  • Remove the fields from right hand side under properties tab by clicking on Edit fields that we do not require for this article like Title and Attachments.
  • Under the properties tab, click on Edit field, in all the given fields select the Control type to Allowed values.

Set the functionality

  • In the form, select the Region Data card and set Items property to: Distinct(‘Main List’,Region)
  • Select the Country DataCardValue, unlock the properties and click on Depends on and in the Matching filed select Main List as Data source and Region in the Attachment.
  • Under properties, In the Value, select Country from dropdown to display the country.
  • In the form, select the Country Data card and set Items property to:

Distinct(Filter(‘Main List’, Region = DataCardValue12.Selected.Result),Country).

It will show the all the countries from the selected region without duplication.

  • Set the State DataCardValue Items property to: Filter(‘Main List’, Country = DataCardValue13.Selected.Result)
  • In the Region Data Card set the Update property to: DataCardValue12.Selected.Result
  • Similarly change the Update property of country also.
  • For the State DataCard change the update property to: DataCardValue14.Selected.State

Customize the app

  • To customize your app you can also add header and label at the top. For that first add a rectangle from the + icon on the left-hand side. Set its position of x and y to 0 and Change the width to 640 and height to 117 under properties tab on right hand side.
  • From the Insert tab, select Label from the ribbon and set it’s size and position exactly like the rectangle mentioned in the above step. Set Font size to 28, Font Weight Bold, Text alignment as center and set color as white. Set the Text property to “Cascading Dropdown”
  • Following the above steps, it is very easy to create multilevel cascading dropdown in Power Apps using SharePoint. I hope it helps you to create an amazing apps using Power Apps and SharePoint.
Please follow and like us:

Rashmi Kaushik

“Nothing can withstand the power of the human will if it is willing to stake its very existence to the extent of its purpose.” - Benjamin Disraeli. I am Rashmi Kaushik, working as a blogger, Software Consultant and Subject Matter Expert in Cynoteck Technology Solutions Ltd.. I believe hard work, dedication, willingness, desire to succeed, and determination are the collective keys that can open the lock of success. I am MB-200: Microsoft Power Platform + Dynamics 365 Core and AZ-900 Azure fundamentals certified.

Leave a Reply

Your email address will not be published. Required fields are marked *