Announcements
Hello all. It is clear that you can combine two or more tables through a collection by adding them to a new collection one after the other. But is there a syntax for combining two tables in a formula? Sometimes it seems like an overkill to create a collection to do something simple like finding the top 5 products in two or more tables.
What I mean is something like the Table.Combine function of Power Query.
Not today - to combine multiple tables you will need to use Collect (or ClearCollect) into another table, and then use that table in your formula.
Please create a new item in the PowerApps Ideas board, if you feel that this feature is important to you.
For anyone wondering the answer, actually it is posible:
Ungroup(Table({MyTables: TableA},{MyTables: TableB}), "MyTables")
Original answer:Solved: Solved: union operator or function to append one t... - Power Platform Community (microsoft.com)
Thank you, I had hoped this would be possible somehow. Your method worked like a charm to create my 1400 record list that combined to separate lists (members of mail groups)
Table(TableA, TableB)
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 519 Most Valuable Professional
11manish 489
Haque 327
