cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MartinHutchcpa
Level: Powered On

Parsing and XMl file

Hi,

I am trying to parse an XML file that it stored in Sharepoint.

The file is loaded ok and when I check the first compose statement, the output is the full XML file.

However when I use xpath in a second compose step to search for a string/node the input is showing as [ ], i.e. empty.

 

Any ideas anyone, please!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Parsing and XMl file

Hi @MartinHutchcpa ,

 

Could you share a screenshot of the Flow configuration and details of expression?

If possible, could you provide a similar xml file for us to do further testing?

 

Please check if File content is encoded. If so, you may also need to use base64ToString() function to convert File content to a String value first.

Also for Parse XML data, please refer to similar thread and see if it helps:

Having-trouble-with-xPath-please-help

Iterate-XML-with-flow

Parse-XML-using-Microsoft-Flow

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User
Super User

Re: Parsing and XMl file

The question is whether the output represents an XML document or just a string formatted as an XML document.  To use Xpath I think it needs to be an actual XMLDoc. Take a look at the following other post and note that in order to use XPath they encolse the output of the original Compose in an XML() function.  Are you doing something similar?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Community Support Team
Community Support Team

Re: Parsing and XMl file

Hi @MartinHutchcpa ,

 

Could you share a screenshot of the Flow configuration and details of expression?

If possible, could you provide a similar xml file for us to do further testing?

 

Please check if File content is encoded. If so, you may also need to use base64ToString() function to convert File content to a String value first.

Also for Parse XML data, please refer to similar thread and see if it helps:

Having-trouble-with-xPath-please-help

Iterate-XML-with-flow

Parse-XML-using-Microsoft-Flow

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MartinHutchcpa
Level: Powered On

Re: Parsing and XMl file

Thanks, it was the base64tostring that I needed to incorporate.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 70 members 4,301 guests
Please welcome our newest community members: