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

(1) Share

Report

Posted on by Ganesh_naga

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

ARGENTINA

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..

All responses (3)

Answers (0)

Ganesh_naga 56 on at

Like (1)

Report

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

Hi Anand,

For the line ddCountry.Selected.Country_Code, I am not getting Country_Code. Only showing ddCountry.Selected.Value
anandm08 1,936 Super User 2025 Season 1 on at

Like (1)

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

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
mmbr1606 12,108 Super User 2025 Season 1 on at

Like (1)

Report

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

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