I have list in SharePoint online which has data of cities. Against each record there is a column state.
- Mumbai --> Maharashtra
- Kagal --> Karnataka etc.
I want to create a new aspx page which will have two dropdowns one for state and one for city.
On selecting a particular state other dropdown should get auto populate. If i select Maharashtra as a state other dropdown should only show cities of Maharashtra.
Can you guys please help me out?
Thanks for the help in advance.