Unanswered

Combining two or more tables in a formula? (not via a collection)

(1) Share

Report

Posted on by Steelman70

873

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

CarlosFigueira on at

Like (0)

Report

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.

Was this reply helpful? Yes No
wldwal 5 on at

Like (2)

Report
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)

Was this reply helpful? Yes No
Florida712 78 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Ondrix 101 on at

Like (0)

Report

@wldwal

Thanks for sharing your solution was fast, simple and easy to understand. Your answer should be marked as verified answer

Was this reply helpful? Yes No
CarlosFigueira on at

Like (0)

Report
As of a few months ago, you can use the Table function to combine two tables:

Table(TableA, TableB)

Will return a table with all elements of TableA, followed by all elements of TableB.

1 people found this reply helpful.

Was this reply helpful? Yes No