Power Automate: Inner Joins like in SQL | Merge lists based on 1 or more keys 

Discover how to efficiently merge lists in Power Automate, just like SQL joins! This tutorial guides you through a step-by-step process of combining lists without unnecessary ApplyToEach, using XML and XPath. Perfect for beginners and seasoned users alike who need complex merging.
🔗 Sign up for our free live Office Hours or to get the Code shown here:
forms.office.com/r/9jSy9dkPUF
00:00 - Intro to Power Automate List Merging
00:34 - Understanding the Lists: Fruit and Veggie Farmers
00:55 - Convert data to XML
01:45 - XPather to play with data
02:10 - ChatGPT to help with create XPath
03:01 - XPath Example
03:33 - Main Event: Add Property (SQL Join on 1 Key)
06:50 - Advanced Joining: Join on multiple keys
08:46 - Source Code & free training
09:04 - Kudos to Paulie M