How to insert variable in power automate xpath expression

Like (0) Share

Report

Posted on 26 Feb 2021 17:03:53 by acrespo

Hello,

Trying to replace "FacturaElectronica" in the expression bellow by a variable: variables('TipoDoc'). Tried to build the string with concat() but have not been able to make it work.

xpath(xml(outputs('Obtener_contenido_de_XML_2')), 'string(/*[name()="FacturaElectronica"]/*[name()="Emisor"]/*[name()="Nombre"])')

Any suggestions? Thanks

Categories:

Business Process Flows

I have the same question (0)

All responses (4)

Answers (1)

manuelstgomes 6,625 on 26 Feb 2021 at 17:35:56

Like (1)

Report
Re: How to insert variable in power automate xpath expression

Hi @acrespo

Try copying with the following structure:

@{variables('TipoDoc')}

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
acrespo 10 on 26 Feb 2021 at 19:05:28

Like (0)

Report

Re: How to insert variable in power automate xpath expression

Thanks Manuel -

This gives me an invalid expression and doesn't allow to save even (also without the @):
xpath(xml(outputs('Obtener_contenido_de_XML_2')), 'string(/*[name()=@{variables('TipoDoc')}]/*[name()="Emisor"]/*[name()="Nombre"])')

This is the closest I have gotten but somehow the xpath doesn't work, it just returns the concatenated string instead of the xml content:
xpath(xml(outputs('Obtener_contenido_de_XML_2')), concat('''string(/*[name()=',variables('TipoDoc'),']/*[name()="Emisor"]/*[name()="Nombre"])'''))

Any other ideas I should try?

Thanks,

Was this reply helpful? Yes No
Verified answer

v-litu-msft on 01 Mar 2021 at 03:28:36

Like (2)

Report
Re: How to insert variable in power automate xpath expression

Hi @acrespo,

You could do like this:

1. Store the Xpath into a Compose action;

string(/*[name()="@{variables('TipoDoc')}"]/*[name()="Emisor"]/*[name()="Nombre"])

2. Append the output of Compose into the second parameter of Xpath() function:

xpath(xml(outputs('Obtener_contenido_de_XML_2')), outputs('Compose_4'))

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
darkramuh 11 on 09 Jan 2023 at 15:49:26

Like (0)

Report

Re: How to insert variable in power automate xpath expression

If you using a lot of Xpath expressions in one action and don't want to create for each separate "Compose" action as per previous answer, You also can use "concat"

xpath(xml(outputs('Obtener_contenido_de_XML_2')), concat('string(/*[name()=',variables('TipoDoc'),']/*[name()="Emisor"]/*[name()="Nombre"])'))

Was this reply helpful? Yes No