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

[@PaulieM]

Neat video, nice one! 💯

[@Untethered365]

Thanks man! You were the inspiration.

[@PaulieM]

@@Untethered365 I saw that and appreciate you! Looking forward to see your future videos.

[@markweyman]

I already subscribe to PaulieM and have seen his video; love your use case. I have to combine several CSVs, and this is how I will do it. TY both :)

[@SeanAstro]

Glad to hear! Paul is the man.

[@travistaylor742]

Hey there - Great video, just had a question: at 4:39, you are passing an XML object into a Select node - right as you are adding the "addproperty" into the map. I am getting an error at this stage, the select node only wants to take an array, not an object. Are you wrapping your XML output in something else to make the Select work properly?

[@Untethered365]

Great question! In this case it should be an array in both settings so make sure you're selecting the node properly in the xpath expression.