Compare Lists and Arrays | Spot the Difference in Power Automate with NO Apply to Each
In this tutorial, you'll learn how to efficiently compare two SharePoint lists - a master list and a regional sales-based list. The video covers the process of identifying and adding missing items from the regional sales list to the master list without using the "Apply to each" action. The tutorial includes an overview of the lists, building the flow, creating a Primary ID Array, validating the flow output history, creating items in the master list, and more. This tutorial is helpful for anyone working with large datasets and aims to ensure efficiency and prevent throttling or hitting API limits. Connect with the creator on Twitter and LinkedIn for updates and check out the blog post for more information.
Video 15m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time