cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
maheshmacintosh
New Member

Retrieve xml element value

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>

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
A_I
Regular Visitor

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

View solution in original post

3 REPLIES 3
burque505
Helper V
Helper V

@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:

should get this.PNG

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',

read xml.png

after running and clicking on the variable, we get only a single property':

books.xml.png

The single property '.XmlNode' is shown. Clicking 'more' we get this:

more.png

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

 

A_I
Regular Visitor

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

View solution in original post

shindomo
Continued Contributor
Continued Contributor

Hello @maheshmacintosh 

 

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

 

shindomo_0-1633527110254.png

 

Result:

shindomo_1-1633527288569.png

 

Thank you.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,922)