Power Platform Community Forum Thread Details

how do you create a table that outer joins?

Table 1

Department Name Facility Name

Dept 2 North

Table 2

Department Name Facility Name

Dept 1 Blank

Dept 2 Blank

Result Table

Department Name Facility Name

Dept 1 Blank

Dept 2 North

Categories:

General Questions

Not in the conventional sense. There are no keywords etc to do that.

If you did a ClearCollect(Collection1, Collection2). You end up with a merge/append, where all the new fields in Collection 2, get added to the Collection1 columns and are NULL. All the Collection2 columns that match Collection1 in name and *type, just are there, and any Collumns in Collection 2 that were not in Collection one are simply merged in with their values.

You would have to do some definite work (addColumns, ifs compares blah blah ) to do what you are asking.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey