Power Platform Community Forum Thread Details

Hello everyone,

I have a document with namespaces which I need to process, when I try to use Power Automate Desktop with that it errors but when I try the query in online builder everything works.

So I have a flow in Microsoft Power Automate Desktop because I need to parse body of the email and press link in email body to download a XML document (incoming invoice) and for that purpose I did not publish any information about that.

I have managed to do that with parse text action where I have built regex to extract information but I want to know how to work with this kind of documents.

This is part of the XML document which I want to process, do you know what kind of XPATH query do I need to build to let's say get data from element ext:ExtensionAgencyName.

<?xml version="1.0" encoding="utf-8"?>

<OutgoingInvoicesData xmlns:xsd="http://www.w3.org/2001/XMLSchema"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns="http://fina.hr/eracun/erp/OutgoingInvoicesData/v3.2">

</Header>

<Invoice xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2"

xmlns:sac="urn:oasis:names:specification:ubl:schema:xsd:SignatureAggregateComponents-2"

xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"

xmlns:sig="urn:oasis:names:specification:ubl:schema:xsd:CommonSignatureComponents-2"

xmlns:ext="urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2" xsi:schemaLocation="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2 HRInvoice.xsd"

xmlns="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2">

<ext:UBLExtensions>

<ext:UBLExtension>

<cbc:ID>HRINVOICE1</cbc:ID>

<cbc:Name>InvoiceIssuePlaceData</cbc:Name>

<ext:ExtensionAgencyID>TESTING</ext:ExtensionAgencyID>

<ext:ExtensionAgencyName>TESTING</ext:ExtensionAgencyName>

<ext:ExtensionAgencyURI>TESTING</ext:ExtensionAgencyURI>

<ext:ExtensionURI>urn:invoice:hr:issueplace</ext:ExtensionURI>

<ext:ExtensionReasonCode>MandatoryField</ext:ExtensionReasonCode>

<ext:ExtensionReason>Mjesto izdavanja računa prema Pravilniku o PDV-u</ext:ExtensionReason>

<ext:ExtensionContent>