Retrieve xml element value

(1) Share

Report

Posted on by maheshmacintosh

Hi,

Below is the xml and need to retrieve only market value.

I tried providing "root/documents/document/market" in XPath query in "Get XML element value" but it retrieves nothing.

Please help me in this regard. Thanks in advance.

<?xml version="1.0" encoding="utf-8"?>
<root>
<documents>
<document>
<isSpecimen value="False" />
<report value="ReportTest" />
<type value="Parent" />
<market value="CountryTest" />
</document>
</documents>
</root>

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

burque505 398 on at

Like (1)

Report
Copy link

Link copied!

@maheshmacintosh, I believe you have discovered a bug.
I ran a small test with the file 'books.xml' from Microsoft available here.
I also viewed the video at this link. At approximately 4:49 in the video, the following screen is shown:
Obviously this is based on a different XML file, but we should still get a list of properties. We don't.
For the file 'books.xml',
after running and clicking on the variable, we get only a single property':
The single property '.XmlNode' is shown. Clicking 'more' we get this:
In short, it appears to me that this Action is not functioning properly. I feel it is safe to assume the remainder of the XML Actions may also not be functioning properly.
Regards,
burque505

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

A_I 16 on at

Like (1)

Report
Copy link

Link copied!

With that syntax, use Get XML element attribute instead of Get XML element value

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello @maheshmacintosh

As @A_I already said, you have to use action "Get XML element attribute" for this purpose.

Result:

Thank you.

Was this reply helpful? Yes No