Get only the value

[rgparisoto]

Hi guys!

I'm using a flow to get some values from a XML file.

To get the values, I'm using the "xpath(xml(" function with compose.

But, the result comes with ["00000000"] (for example).

What I have to do to have only the 00000000 value?

Because I need it to insert rows at a SQL Server table and made another select.

Thank you so much.

Robson.

[v-bacao-msft · Accepted solution]

Hi @rgparisoto ,

It seems that this result is an array, you could use the index to get the element, like:

xpath(xml(),'')[0]

Please take a try.

Best Regards,

[rgparisoto]

Thank you so much @v-bacao-msft !

Your answer help me with another problem, thank you so much.

But, I still have the same as a start the question, look:

Here I'm using the 'xpath'Here, the query with the result of 'xpath'

I wanna have only the part inside, this 33136405000100.

There are any way to do it?

Thank you again,

Robson.