You’re offline. This is a read only version of the page.
32
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
Hi @CCW ,
Assuming you have a "matching" column in both lists (I will use Fruit for both below) and your dropdown had Items something like
Share
Report
All responses (
Answers (
ListName1.Fruitthen the second drop-down Items would be
Filter(
ListName2,
Fruit = DD1.Selected.Fruit
).Country
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hello,
1st dropdown is list of line type and as per selected value 2nd dropdown will show the record.
For list of 2nd dropdown , I created 6 dropdown and placed that on same position & apply if condition on visible property to each dropdown.
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
