cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kavya_M
New Member

Data extraction from Dataverse Tables to single XML format file

Extract the data from two related Dataverse tables to XML file using only PowerAutomate/PowerApps. Is that possible?

1 REPLY 1
ChrisPiasecki
Super User
Super User

Hi @Kavya_M,

 

Power Automate has an XML expression which you can use to convert the JSON body output of a List Rows action to XML. Here is an example of how to achieve it.

 

You'll need to take the child dataset and merge it into the parent dataset xml which you should be able to do with a Compose action.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (3,995)