App Connect provides a built-in XML parser that you can use to map XML data from an event or action to a subsequent node in a flow. The XML parser transforms a string of XML text in UTF-8 encoding into an XML object representation of the string. The parser supports versions 1.0 and 1.1 of the XML specification.
FILTERXML Function as a Dynamic Array. If you’re using Excel for Microsoft 365, then you can use the FILTERXML function to split text with output as a dynamic array. You can split a text string by turning it into an XML string by changing the delimiter characters to XML tags. This way you can use the FILTERXML function to extract data.