none
unable to parse XML using Microsoft Flow RRS feed

  • Question

  • Hi ,

    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.

    

    Friday, November 16, 2018 9:38 AM

All replies

  • Hi Bharti,

    As we mainly talked about SharePoint Online related question in this forum, I would suggest you could create a new thread in the Flow forum which is focused on Flow related question:

    Microsoft Flow Community Forums Get Help with Microsoft Flow Connecting To Data

    You will need to registered a new account in the Flow forum and then you could  get more help based on the Flow related question.

    Thanks for understanding.

    Best Regards


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Monday, November 19, 2018 9:43 AM