web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Parsing XML with xpath...

Power Automate

Unanswered

Parsing XML with xpath using dynamic XML string

(0) Share

Report

Report

Posted on by famcanico10

5

Hi,

I'm trying to parse an XML string value from the "text" field under "post" entity in Dynamics 365.

Here's is the sample value of the field:

"<?xml version="1.0" encoding="utf-16"?><pi id="Account.Create.Post" icon="0" ya="1"><ps><p type="1" otc="8" id="ff87e0f2-813f-eb11-bf68-000d3a3abbc3">David So</p></ps></pi>"

I'm assigning that value to a Compose step then uses another Compose (Compose 2) step to parse it using xpath

I am trying to get the string value, David So, of the p node but I'm getting this error:

is there anything wrong with the syntax of the expression I'm using?

I'd appreciate any feedback on this. thank you.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!
@famcanico10 I was able to extract the information you need.

xpath(xml(outputs('Compose')),'string(//p)')
Output :

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!

@famcanico10 I am also facing same issue with <?xml version="1.0" encoding="utf-16"?> but if I change it to <?xml version="1.0" encoding="utf-8"?> it just works fine. So it looks some issue with the encoding tag if possible change it to utf-8 and try and it should work.

I could not find any example of documentation where utf-16 was used or demonstrated, but feel free to go through below links and confirm again.

More details about Xpath function, please check the following article:
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#x...

More details about Xpath examples, please check the following article:
https://msdn.microsoft.com/en-us/library/ms256086(v=vs.110).aspx

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No

Join the conversation