Power Platform Community Forum Thread Details

How to iterate over XML returned from SOAP

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:-