I have two arrays within my Power Automate Flow coming from SharePoint List.
I need to add two compose actions
1 - This should give me all elements in both arrays but the common elements should appear only once
2 - This should give me elements which are common in both (but show them only once)
- Array1:
['Houston', 'London', 'Paris', 'Barcelona']
- Array2:
['Seattle', 'Paris', 'Brussels', 'Rome']
For above,
1 - This will give me Houston, London, Paris, Barcelona, Seattle, Brussels, Rome -- note Paris appears only once
2 - This will give me Paris
Thanks!
