Combining multiple collections into one for (potentially) view-only purposes

[Stoikryz]

Hello!

I have 5 collections, some with different columns(Some columns will be going away, I'm still learning the best way to set these up). These 'line item' collections need to appear on one screen before they're fully Submitted to my datasource(Think a confirmation screen overview), and I was thinking if I could somehow combine them all, passing in null or blank values in the columns with no data.
They're designed to be relatively dynamic, and any of these collections could have no records.

colMaterials

ID	Desc	MaterialID	Qty	TempKey	Totals	UnitPrice	UoM

colEquipment

ID	Desc	EquipmentID	Other	Qty	Totals	UnitPrice	UoM

colLabor

ID	Descr	Hours	Labor	Rate	Totals

colMileage

ID	Desc	Markup	MileageID	MileageRate	Miles	Qty	UnitPrice	UoM	Totals

colOther

ID	Desc	Other2	Other3	OtherID	Qty	Totals	UnitPrice	UoM

Currently, I have a Datatable with the following code, however if a collection happens to be empty (Say colLabor for instance), but colEquipment and colMileage both have data, then PowerApps inserts a blank record in between. I also have no 'logic' in editing records from this data table.

Ungroup(
    Table(
        {Items: colMaterials},
        {Items: colEquipment},
        {Items: colLabor},
        {Items: colMileage},
        {Items: colOther}
    ),
    "Items"
)

Does anybody have any ideas of where I could start looking? Thanks in advance!

Optional goal: ideally I would like either an editable grid situation where my users can make changes right from that page, or at least a way to link back to that specific record to edit it on the actual edit screen. (Each Collection has its own screen where users can add, remove, or edit records; the Confirmation screen is where the final "Submit" patch is performed)

[v-liwei-msft · Accepted solution]

Hi @Stoikryz ,

Could you please tell me: 

1.If you want to make collection not appear in the table when it is empty?

2.If collection colLabor is empty?

I suggest you use this formula:

Ungroup(
Filter(
Table(
{Items: colEquipment},
{Items: colLabor},
{Items: colMileage}
),
!IsEmpty(Items)
),
"Items"
)

Best Regards,

Levi