Provide "Union" method in Named Formulas

[kayetter]

I am following the advice from MS here Build large and complex canvas apps - Power Apps | Microsoft Learn where there is a whole section called 'Use named formulas everywhere'.

One thing I encounter is the inability to "union" two Tables. In the normal app I would just use two seperate "Collect" statements to add more records to a collection. This is not possible in the Named Formula section.

Would it be possible to provide a "Union" type method in this area? Or is there some other way to do this?

[lesaltzm]

This would be good to add generally. I'd lean away from Union since that seems more like an operation on Sets or Types imo. C#'s IEnumerable picked Concat for this, but we already use Concat for string operations, so perhaps Append(Table, Table, [Table, ...]): Table?

+ @gregli-msft , @jorisdg

[kayetter]

Sounds good to me. Whatever you all decide. I just encountered another instance where I would like to have this feature.

[rnwood]

Dupe of #1819