web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Cascading drop for Cou...

Power Apps

Unanswered

Cascading drop for Country and State based on lookup field from other list

(1) Share

Report

Report

Posted on by Ganesh_naga

56

Hi Team,

Need to display Country and State value in to two different dropdown based on the selection from two different lists.

Country List:

Country_Name Country_Code

UNITED STATES

US

ARGENTINA

AR

State List:

State_Name State Code Country_Code (lookup column from Country list)

Corrientes	04	AR
Entre Rios	05	AR
Jujuy	06	AR
Mendoza	07	AR
Alaska	AK	US
Alabama	AL	US
Arkansas	AR	US

Poweapps:

Country Dropdown: Should display Country_Name

State Dropdown: Should display State_Name list based on the Country selected.

Please assist how to write the formula for both the fields will be a great help..

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

hey @Ganesh_naga

this video should show everything you need to know:

How to create Cascading (Dependent) Dropdowns in Power Apps (youtube.com)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
hi @Ganesh_naga ,
Assuming you have two SharePoint lists or collections (CountryList and StateList) as described:
CountryList contains:
Country_Name (Text)
Country_Code (Text)
StateList contains:
State_Name (Text)
State_Code (Text)
Country_Code (Lookup to CountryList)
Step 2: Set the Items property of the Dropdowns
Country Dropdown (ddCountry)
Set the Items property of the Country dropdown (ddCountry) to display Country_Name from CountryList:

CountryList.Country_Name

State Dropdown (ddState)
Set the Items property of the State dropdown (ddState) to filter StateList based on the selected Country_Code from ddCountry:

Filter(StateList, Country_Code = ddCountry.Selected.Country_Code).State_Name

Was this reply helpful? Yes No
Ganesh_naga 56 on at

Like (1)

Report

Hi Anand,

For the line ddCountry.Selected.Country_Code, I am not getting Country_Code. Only showing ddCountry.Selected.Value

Was this reply helpful? Yes No

Join the conversation