web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : e92q9i/ykMH1JG8WLwFHRZ
Power Automate - Using Connectors
Unanswered

Unable to Parse the XML data using Microsoft flow

Like (0) ShareShare
ReportReport
Posted on 19 Nov 2018 11:17:08 by

I have the XMl in below Format , I need all my XML tags to be moved in SP list. (PID_NO,EmailId,...) . But ubale to parse the xml

<project-list>
<ProjectId>
<PID_NO>21100906</PID_NO>
<email_id>abx@outlook.com</email_id>
<frm_date>2017-11-01 00:00:00.0</frm_date>
<proj_name>Sharepoint</proj_name>
<to_date>2017-11-01 00:00:00.0</to_date>
</ProjectId>
<ProjectId>
<PID_NO>21100968</PID_NO>
<email_id>abcd@outlook.com</email_id>
<frm_date>2018-03-28 00:00:00.0</frm_date>
<proj_name>Internal</proj_name>
<to_date>2018-09-25 00:00:00.0</to_date>
</ProjectId>
</project-list>

 

this is the flow I am using

1) calling HTTP - Getting XML in body

2) body('http')['$content']   ----  compose 

3) xpath(xml(outputs('Compose')),'string(/ProjectId/PID_NO)')

4) apply to each - array(outputs('Compose_2'))

5) compose - xpath(item(),'string(PID_NO)')

but when I test the flow, Output in step 3 is not xml - Contenttype encoding. no data receiving in step 5.

  • v-yamao-msft Profile Picture
    on 20 Nov 2018 at 07:46:13
    Re: Unable to Parse the XML data using Microsoft flow

    Hi @Anonymous,

     

    I assume that the xpath function could be used in your scenario, please check more details about it at here:

    https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#xpath

    More details about xpath examples, please check it at here:

    https://msdn.microsoft.com/en-us/library/ms256086(v=vs.110).aspx

    Besides, here is a blog on how to parse xml using Microsoft Flow, for your reference:

    http://buildsharepointconcepts.blogspot.com/2018/05/parse-xml-using-microsoft-flow.html

     

    Best regards,

    Mabel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics