How to Compare Two Lists in Power Automate Without Apply to Each

In this tutorial, I'll guide you through a detailed demonstration of how to efficiently compare two SharePoint lists - a master list and a regional sales-based list. Learn how to identify and add any missing items from the regional sales list to the master list, comparing the two arrays without using the "Apply to each" action.

Intro (00:00): Begin your journey with an overview of what's to come.

The Lists to Compare (00:35): Understand the two SharePoint lists we'll be comparing and their importance.

Building the Flow (02:07): Learn how to build an efficient flow to handle the comparison and addition of missing items.

Primary ID Array via Select (03:02): Explore the creation of a Primary ID Array using the 'Select' function, an essential part of our flow.

Validating the Flow Output History (05:28): Dive into validating the flow output history, ensuring your flow is running as expected.

Creating Items (06:32): Discover the process of creating items in the master list from the regional sales list

New Designer Dynamic Value Bug? (07:37): Discuss a potential bug in the new designer dynamic value.

Validating Item 6 has been created (09:10): Verify the successful creation of a new item in the master list.

Running the Flow on some more items (09:37): Watch the flow in action on several more items, demonstrating its efficiency and scalability.

Outro (10:45): Wrap up the session with key takeaways and a look into what's next.

This tutorial is perfect for anyone dealing with large datasets, ensuring efficiency and preventing throttling or hitting API limits. Make sure to connect with me and subscribe to stay updated with more such useful tutorials!

Join the conversation on Twitter: twitter.com/damobird365
Follow for updates on LinkedIn: linkedin.com/in/damobird365
Explore more on the blog: damobird365.com

Want to watch more efficient videos ? Check out this play list    • Power Automate Efficiency  

Blog post- compare two arrays https://pnp.github.io/blog/post/compa...

Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕