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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to iterate over XM...
Power Automate
Unanswered

How to iterate over XML returned from SOAP

(0) ShareShare
ReportReport
Posted on by 1,811 Super User 2024 Season 1
I have this XML returned from SOAP call:-
 
 
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:soap="http://www.w3.org/2003/05/soap-envelope"><env:Header xmlns:env="http://www.w3.org/2003/05/soap-envelope"><wsa:Action>https://service.leads360.com/GetReportResultsResponse</wsa:Action><wsa:MessageID>urn:uuid:b5e15028-48af-4e99-8bbe-ee10ada6eb8c</wsa:MessageID>
<wsa:RelatesTo>urn:uuid:49aac50b-6dec-48d0-b157-f7e10c6fa83c</wsa:RelatesTo>
<wsa:To>http://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous</wsa:To><wsse:Security><wsu:Timestamp wsu:Id="Timestamp-4ffa884d-4047-4b01-ab62-3d0aa3c3c2f8">
<wsu:Created>2024-10-22T14:20:11.490034Z</wsu:Created><wsu:Expires>2024-10-22T14:25:11.490034Z</wsu:Expires></wsu:Timestamp></wsse:Security></env:Header>
<soap:Body>
<GetReportResultsResponse xmlns="https://service.leads360.com"><GetReportResultsResult>
<ReportResults reportId="1501" xmlns="">
<Result>
<LogType>Assignment</LogType>
<LogActor>***</LogActor>
<LogDate>2024-10-22T06:01:45</LogDate>
<LogResult>Grant Gordon</LogResult>
<LogNote>To: [Grant Gordon]</LogNote>
<Id>4198686</Id></Result>
<Result>
<LogType>Assignment</LogType>
<LogActor>***</LogActor>
<LogDate>2024-10-22T06:01:45</LogDate>
<LogResult>Grant Gordon</LogResult>
<LogNote>To: [Grant Gordon]</LogNote>
<Id>4197833</Id></Result>
now i want to ApplyToEach the ReportResults  and add the values of the LogType, LogActor into a sharepoint list.. but i am unable to parse this XML.. any advcie?
 
I tried to compose the SOAP result >> convert it to JSON >> Build an Array:-
 
 
 
but it did not work.. where i only get one item inside the "Apply to each" any advice?
Thanks
Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard