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.
Hi @Anonymous,
I assume that the xpath function could be used in your scenario, please check more details about it at here:
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