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.
Solved! Go to 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,
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,
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
14 | |
13 | |
11 | |
10 | |
9 |
User | Count |
---|---|
31 | |
21 | |
16 | |
14 | |
12 |