Compare two arrays (e.g. SharePoint lists) using Power Automate

Power Automate doesn't have a built-in function to compare arrays, but you can use a workaround. To compare two lists or arrays, you need to first get the data into Power Automate. Use the "Get items" action to retrieve the values from each list and use the "Select" action to choose the values you want to compare (e.g., email addresses). Then, use the "Filter array" action to compare the two arrays. Set the bigger array as the "From" value, the smaller array on the left side, and use the "item()" expression on the right side. This will give you an array with the values from the first array that are missing in the second array. This approach can be used to compare any arrays, including arrays with objects.

Article 3m Tom Riha

---

Login now to access my digest by 365.Training

Login