Extract information from XML file

Like (0) Share

Report

Posted on 24 Oct 2023 01:38:47 by apolodor0

Hello to everyone, I need for your help. I'm trying to extract some information from this xml file.

<?xml version="1.0" encoding="utf-8"?>
<root>
<page>
<item name="Modelo(Zonal OCR)" value="IM 550F" />
<item name="Serie(Zonal OCR)" value="3209X711378" />
</page>
<page>
<item name="Modelo(Zonal OCR)" value="" />
<item name="Serie(Zonal OCR)" value="" />
</page>
</root>

This file is generated trought a scan application, that extract some information by OCR, this informations is rendered in an index file in format txt, csv or xml. With this information, i try to create a new element in a list, or update the properties into a file in a document library. But i can't obtain the information for "Modelo" or "Serie"

I try to use the xpath function like this

"xpath(outputs('xml'),'//*[local-name()="root"]/page[1]/item[1]/@value'), but it only returns an error."

How i can acces the values of "Modelo" or "Serie".

Tahnks for your help

I have the same question (0)

All responses (6)

Answers (2)

apolodor0 8 on 24 Oct 2023 at 13:14:26

Like (0)

Report

Re: Extract information from XML file

Thanks a lot, it works perfectly

Was this reply helpful? Yes No
Chriddle 7,980 Super User 2025 Season 2 on 24 Oct 2023 at 11:49:42

Like (1)

Report
Re: Extract information from XML file

Also note that you can also convert XML to JSON and use the usual methods to access values:

json(xml(outputs('XML')))
body('Parse_JSON')['root']['page'][0]['item'][0]['@value']

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on 24 Oct 2023 at 07:51:58

Like (0)

Report
Re: Extract information from XML file

Hi @apolodor0 ,

As @ManishSolanki mentioned, please try:

xpath(xml(outputs('xml')), 'string(/root/page[1]/item[1]/@value)')

Best Regards,
Bof

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,087 Super User 2025 Season 2 on 24 Oct 2023 at 04:48:18

Like (1)

Report
Re: Extract information from XML file

Hi @apolodor0

Pls use the below expression to extract the required text:

xpath(xml(outputs('xml')), 'string(/root/page[1]/item[1]/@value)')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
apolodor0 8 on 24 Oct 2023 at 03:00:30

Like (0)

Report

Re: Extract information from XML file

Thanks a lot @v-bofeng-msft, it really works. Only one more thing, this function returns the value
"value=\"IM 550F\""
And when i use it to create a new element in a sharepoint list, it use the whole string
"value=\"IM 550F\"", but i only need the string IM 550F. In Xpather, the result is only IM 550F,,
how can obtain only the string i needed?
So sorry, but i don't have a lot of knowledge in XML or Automate.

Thanks for your help again

Xpather.png

Was this reply helpful? Yes No
v-bofeng-msft on 24 Oct 2023 at 02:28:07

Like (1)

Report
Re: Extract information from XML file

Hi @apolodor0 ,

Please try:

xpath(xml(outputs('xml')), '/root/page[1]/item[1]/@value')

Best Regards,
Bof

Was this reply helpful? Yes No