PowerPlatformTip 24 – ‘Merge arrays or tables’

Sometimes you may want to merge two arrays, including duplicates. Using the union function will merge the arrays, but it will only keep unique values. A simple trick to accomplish this is by concatenating the arrays and then getting the duplicates. split( concat( join(outputs(‘Compose_-_2_arrays’)?’array1′],’||’), ‘||’, join(outputs(‘Compose_-_2_arrays’)?[‘array2’],’||’)), ‘||’) If you want to see the overview above […]