I have multiple excel tables on my canvas app. Depending on the selection from a drop down I want to be able to show the table data in the next drop down.
e.g. drop down 1 is a list of fruit, drop down 2 is a list of countries the fruit is from - I will add, the reason the data is split between multiple tables is just down to the quantity of rows. Performance seems to be a lot better using split tables - there would be in excess of 5000 rows if it was just on one table.
User selects Oranges from DD1
I would like DD2 to show the data item "oranges" and the Country header from that table.
I've made quite a clunky workaround to do this but I wondered if there's a better way of doing it?
I've got another table with the data table name, when the user populates DD1 there's a lookup that returns the data item name. from there, I've got a series of If formulas to decide which drop down to show the user.
This works but even with a lot of notes, it may be difficult for someone to go into this and make changes at a later date
