Forum Discussion
linking dropdowns from different tables.
Morning, I am hoping someone can tell me if this is possible.
I have a dynamic dropdown list which limits the options of dropdown 2 depending on what is chosen on dropdown 1 (e.g. I have a list of people and cities, so dd1 will be the list of cities, so if I pick the UK only the people in the UK will be available to be chosen from dd2)
In another table I have the details of that person created from a unique list so a table is populated with all their info. (E.g. I chose Charles and all his info is auto generated into a new table, numbers, dates, products, etc)
my question is, is there a way to connect the two pieces together.
I want to be able to pick the name first, which will still auto-populate the table with all his associated data and under that have a dropdown where I can show the city/names associated.
so for example:
Charles -populates his table
under that is a dropdown that automatically shows the cities associated with that name
I feel like I am maybe making this more complicated than it needs to be. but any help getting me out of the tunnel vision I seem to have would be great.
- Is this in Excel?
This sounds like a solution for Canvas apps https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/getting-started - This board is for things related to Microsoft Learn and Microsoft Certifications. If you want to do this in Excel I would recommend reaching out on the Microsoft Excel Community https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat
- I have reposted, hopefully in the correct place now as I do indeed want it to work on Excel but I will look into the power-app thing at a later date. Thank you.
- You can use Excel as the data source for a Canvas app and a lot of the functions/formulas are the same as Excel
