XML response to file.xml or Excel

crmkeeper · ‎10-16-2019

Background:
I am connecting to an API that returns XML. I was hoping for JSON but I was not that lucky.

The result of my ask is a structured .xml file or even better an Excel file so i can use PowreApps Dataflow for import to CDS.

Why, because i can't figure out how to import the XML response to with xPath in a "for each" setting.

<?xml version="1.0" encoding="utf-8"?>
<Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<Body>
		<GetProjectListResponse xmlns="http://24sevenOffice.com/webservices">
			<GetProjectListResult>
				<Project>
					<Id>
						2100009531
					</Id>
					<Name>
						Yolo
					</Name>
					<RawName>
						Yolo
					</RawName>
					<NameDisplay>
						Plain
					</NameDisplay>
					<DepartmentId>
						-2147483648
					</DepartmentId>
					<TimeReg>
						WorkType
					</TimeReg>
					<Version>
						1
					</Version>
				</Project>
			</GetProjectListResult>
		</GetProjectListResponse>
	</Body>
</Envelope>

v-alzhan-msft · ‎10-16-2019

Hi @crmkeeper ,

Could you please explain more details about your requirement?

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

XML response to file.xml or Excel

Helpful resources

Join us for Microsoft Power Platform Conference

A new place to submit your Ideas for Power Automate

Register for a Free Workshop

Microsoft 365 EduCon