I’m trying to get specific data from sharepoint list. I want user to select from drop down menu and depending selected value get row data from list matching values because i want to fill out particular text fields. For example, drop down menu has many countries and I have a list with 3 columns (country, population, capital city). If user select country A then it shows on a text field population, and capital in other text field corresponding to that country. I know similar tasks can be done with casacading drop downs but this time I think is not the correct way. Hope anyone can help me. Thanks in advance!!!!
FYI: I’m using Sharepoint 2016