Solved! Go to Solution.
Couldn't get your idea working.
But think I have found a better way to do what I need to do. Using queries in Excel I'm able to append tables and filter out projects which have finished.
Get data>combine queries>append
This creates a new table in excel, which I have added as a data source to Powerapps, but for some reason, the dropdown is not populating with the options. Is this type of table treated any differently by Powerapps?
In the attached the top table is linked to my combined query table (Append1), while the lower tables are connected to another table (Contracts) which is not derived from a query.
You could create a collection and then add the drop down values from all three tables to the collection. Then you could use the collection in your actual drop down.
The web link is not working but I'm assuming you mean this video:
Your videos have helped me get to the point I'm at now! but (if the above is the right video) I dont think this answers my question.
I want a single dropdown control which references multiple tables. So using your video example, the singular dropdown list would include departments and colours as options choices..
Would it be simpler to create a table of tables in Excel with something like this:
The tables are dynamic and constantly change.
Guess I would ask what you mean by the tables are always changing? like the structure/columns in the table are changing all the time or just the data?
Then I think I am back to my orginal idea of making one collection in your PowerApp that combines the column you need from both data sources into one column.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.