In this second video, we’re going on a deep dive into XPath expressions in Power Automate.

Using no premium connectors or apply to each loops, we take three sets of data in json format and manipulate that data using XPath expressions. This includes grouping and ungrouping (or “exploding”) that data, adding looked-up properties and merging whole objects together efficiently.

We then take the updated data and use some numerical XPath functions to answer some questions on the example data.

We do all of the above by testing the expressions outside of Power Automate using a small .NET console application in Visual Studio. This way, we are less likely to come across XPath expressions that are not compatible with Power Automate.

Learn more about what you can do with XPath expressions in Power Automate by viewing the XPath syntax page for .NET: https://learn.microsoft.com/en-us/pre...)

Also please see the “nested select” chapter of my previous video, which gives more details about taking an array of nodes output from an XPath expression in Power Automate and converting it back into a native object type:    • Microsoft Forms Quiz Auto-Score in Po...  

As always, any and all feedback is welcome - please let me know if you have any suggestions in the comments below. If you enjoyed this video, please leave a like or subscribe to my channel and I'll do my best to produce more!

Timeline:
00:00 Introduction
05:29 Testing XPath for Power Automate successfully
13:02 Ungroup / Explode
25:19 Lookup
28:33 Group
36:04 Merge
41:38 Numerical calculations
46:59 Video review