Compare 2 arrays

(1) Share

Report

Posted on by DA-20021519-0

I have created 2 arrays, 1 from flagged emails in a shared inbox and 1 from the tasks in a Teams planner

basically I would like to cycle through the emails array and compare the subject of each one to the titles of all the tasks in the panner.

If there is a match, skip, if there is no match, create a new task with the title being the subject of the email

I tried nested Apply to each but seems to cycle around creating duplicate tasks

Is there a straightforward way to do this?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Expiscornovus 33,891 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @DA-20021519-0,

Yes, you could compare two arrays with a filter array action to find the exceptions which don't have a match. After that you can use the outputs of that action in a apply to each loop to create new tasks for those non-matched items.

@DamoBird365 has created a nice blog about this approach (specifically have a look at the Except section).

https://damobird365.com/efficien-union-except-and-intersect-great-method/

If you need additional help/have questions about your use case setup let us know.

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
DA-20021519-0 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Thanks for the reply, that looks really interesting

When I set up the Filter Array action, PA automatically adds in a 'For each' for each flagged email so if there are say, 3 flagged emails it cycles around 3 times and created 3 tasks for every email, i was just expecting the Filter Array to just produce another array which I could process

Would you know how I could fix that?

Many thanks!

Was this reply helpful? Yes No
Expiscornovus 33,891 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DA-20021519-0,

Can you share a screenshot of your current flow setup?

This makes a bit easier to create an example for your setup/give you some pointers into the right direction.

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
DA-20021519-0 11 on at

Like
a
(0)

Report
Copy link

Link copied!

That's super helpful, thank you

This is what I am using to make the 2 arrays to compare

The Init Variables are not used

Many thanks!

Was this reply helpful? Yes No