Remove Duplicates From Power Automate Array Formula

You can remove the duplicates from a Power Automate array in two easy steps: add a Compose action and insert a Union function. The Union function combines two arrays together and returns only unique items.

Example #1: Remove Duplicate Emails From An Array

This Power Automate code shows how to remove the duplicate emails from an array.

Code

EmailsArray variable:

["[email protected]","[email protected]","[email protected]","[email protected]","[email protected]","[email protected]"]

Union function code:

union(variables('EmailsArray'),variables('EmailsArray'))

Result

Example #2: Remove The Duplicate User Records From An Array

This Power Automate code shows how to remove the duplicate user records from an array.

Code

UserArray variable:

[
  {"ID": 1, "Email": "[email protected]"},
  {"ID": 2, "Email": "[email protected]"},
  {"ID": 1, "Email": "[email protected]"},
  {"ID": 3, "Email": "[email protected]"},
  {"ID": 4, "Email": "[email protected]"},
  {"ID": 2, "Email": "[email protected]"}
]

Union function code:

union(variables('UsersArray'),variables('UsersArray'))

Result

Questions?

If you have any questions or feedback about Remove Duplicates From Power Automate Array Formula please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion.