Remove duplicate values from an array using Power Automate Flow

Hello everyone!

In this blog, we will demonstrate how to schedule a flow that sends emails to all the owners of opportunities using Power Automate Flow.

Scheduled flows are the best option for actions that need to be automated on a schedule and will run at a specific time or date. For instance, using this approach, you might schedule a daily data upload to Dynamics 365 or SharePoint.

Use Case: Power Automate flow sends a reminder notification to the owners of Opportunities. To avoid multiple emails being sent to the same owner, we need to remove duplicate email addresses.

Step 1: Log in to the required Power Apps environment using URL make.powerapps.com by providing username and password, click on Create on the left-hand side as shown below, and click on Scheduled cloud Flow.

Step 2: Mention the date and time.

It will appear as this.

Step 3:  Initialize a variable ‘Email_addresses’ of type Array which will store all the email addresses.

Step 4: Use List Rows to find the desired records from the required table. Select the table name. Also, I added the FetchXML code to fetch the required details of an entity.

Step 5: Add an ‘Apply to Each’ loop and insert the previous step’s value. This is done so that the value in every iteration is stored in the Array Variable. Add a step of ‘Set variable’ to store the email addresses in the Array.

Step 6:  Add a new step ‘Compose’ and declare an empty array. This helps to save time when comparing with larger sets.

Step 7: Apply the Union function which removes duplicate values.

union(variables(‘Email_addresses’),outputs(‘Empty_Array’))

Step 8: Apply the Join function to extract the email addresses.

join(array(outputs(‘Union_function_to_remove_duplicate_mail_Values_in_Array’)),’,’)

Hope this helps!