consider i have two columns eg: country & city(both are lookup columns) , what i need is that for eg: I choose Canada as value in country column , then the dropdown values in city column should only contain cities within Canada. likewise for other countries also.. Anyone please help !
1 Answers
1
votes
You are talking about cascading dropdown which is dependent dropdowns with look up fields. All you need to do is Step 1: create a country list Step 2: create a city list Step 3: add a new lookup column in city list named as country which is a look up to country list. Step 4: final output list. In which you will add two lookup columns as Country and City.
Once done with list structure you can use power apps which is most recommended with SharePoint modren sites, SP service code with content editor webpart in classic view of list page or use infopath.
For power apps: https://youtu.be/kzvMbmb5pmo
For sp service code in content editor: https://youtu.be/OcTI_UQ55TM
For info path 2013: https://youtu.be/xm4YQ3FEctw
Please mark answer if this helps you
