Remove duplicate data from a list

In Power Automate Desktop, a variable that can hold multiple values is called a “list”.

This article explains how to remove duplicate data from the values stored in a list.

Implement by copying and pasting

Copy the following code and paste it into the Power Automate Desktop flow designer to add the actions.

Variables.CreateNewList List=> List
Variables.AddItemToList Item: 3 List: List NewList=> List
Variables.AddItemToList Item: 1 List: List NewList=> List
Variables.AddItemToList Item: 1 List: List NewList=> List
Variables.AddItemToList Item: 2 List: List NewList=> List
Variables.RemoveDuplicateItemsFromList List: List IgnoreCase: False NewList=> List

Implement in Power Automate Desktop

1. In “Search actions”, type “Remove duplicate items from list”.
2. Select the target list. When you run the flow, duplicate items are removed from the list so that each item is unique.

Note

The action has an option to ignore the difference between uppercase and lowercase letters when checking for duplicates (IgnoreCase in the code). In the sample, it’s set to False (case-sensitive). This option applies only to lists made up of text.