Marcel Lehmann

learn and find tipps & tricks around the powerplatform

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 all #PowerPlatformTip – click here

Published by

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: