Power Automate - intersection() Function (Cheat Sheet)

𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝗶𝗻𝗴 𝘁𝗵𝗲 𝗣𝗼𝘄𝗲𝗿 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀 𝗖𝗵𝗲𝗮𝘁 𝗦𝗵𝗲𝗲𝘁 𝗦𝗲𝗿𝗶𝗲𝘀 🦹

Since I kind of ran out of ideas for roadmaps, I needed something to keep me inspired when creating infographics.

Then I remembered earlier this week when I was looking for a solution to an issue in Power Automate, stumbling on the intersection() function.

I'd never heard of it until that point, but it solved exactly what I needed at the time.

It got me thinking: what if I can break down these functions so you can see exactly what they do within a few seconds?

And even if you don't need it then and there, at least you know it exists!

So this series is for you people struggling to remember the right syntax for Power Automate and Power Apps!... (basically all of us)

🔥 As mentioned, today I've got you covered with the intersection() function.

👉 Find common elements between arrays & objects

👉 Use it to compare datasets, filter values, and more.

p.s. Huge thank you to Joe Unwin (FlowJoe) who is featured in this Cheat Sheet with an amazing resource breaking down the intersection() function.