Announcements
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.
I made a video on exactly this. 🙂
PowerApps multiple data sources
Hi @Shanescows
The web link is not working but I'm assuming you mean this video:
https://youtu.be/fqH1U0_TanI
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..
@Shanescows @Jeff_Thorpe
Would it be simpler to create a table of tables in Excel with something like this:
https://productforums.google.com/forum/?noredirect=true#!topic/docs/Q25WBZEITj8
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.
I don't think I have exactly covered what you need to do. Let's see if I can mock it up quick...
Do both of your tables have similar structures? What is the column name from each table that you want to combine into one column?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 414
WarrenBelz 377 Most Valuable Professional
Kalathiya 315 Super User 2026 Season 1
