Parse XML in Power Automate and Create records in Dynamics 365 CRM

By | March 15, 2021

Introduction

In Dynamics 365, we can create multiple records through the OOB Import method, by using SSIS Package. In this blog, I will show how to create multiple records from XML using power automate.

Microsoft introduces many new functions, which we can use in Power Automate. Please find the below reference link of the functions.

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#xpath

We need to use “xml” and “xpath” functions to read and parse XML in Power Automate.

Eg. xpath(xml(Output(‘XML’)), ‘/rootnode/items’)

Below are the steps to read and parse XML and create the Account records using Power Automate:

  • We need to prepare standard structure of XML before creating power automate because we need to parse XML based on the format we have.
  • I have created API function to get XML in Power Automate(below is the sample XML value), so accordingly I will write an expression to parse XML in power automate.

<accounts>

<account>

<accountname>Royal Acc Ltd.</accountname>

<phone>1234567892</phone>

<website>royal.acc.in</website>

<street1>321, S. V. Road</street1>

<city>Mumbai</city>

<state>MH</state>

<revenue>500000</revenue>

</account>

<account>

<accountname>MangloreAcc Ltd.</accountname>

<phone>7487596145</phone>

<website>manglore.acc.in</website>

<street1>147, VrundavanSociy</street1>

<city>Manglore</city>

<state>KA</state>

<revenue>1000000</revenue>

</account>

</accounts>

Step1: Create a Flow. Ihave created “Recurrence” flow which will trigger at 1 am every day.

Parse XML in Power Automate and Create records

Step2: Add new steps to get XML value form API.

Parse XML in Power Automate and Create records

Step3: Add compose variable to set output (response body) of Http Request.

Parse XML in Power Automate and Create records

Step 4: Use Xpath expression to read XML value

Parse XML in Power Automate and Create records

Expression:

xpath(xml(outputs(‘Set_Http_Response’)), ‘/accounts/account’)

Here: Set_Http_Response is the previous step name.

Step5: Use ‘Apply for each’ control loop to read multiple records and create the same in CRM.

Parse XML in Power Automate and Create records

In these steps, we need to map the column which we want to populate data in Account from XML node values, using xpath() in expression

Below are some Example:

Account Name = xpath(item(),’string(account/accountname)’)

Address 1 : City = xpath(item(),’string(account/city)’)

Step 6: Save and Run Power Automate. We will get the below response body in HTTP request.

Parse XML in Power Automate and Create records

Output:

Parse XML in Power Automate and Create records

Conclusion

We can create multiple records in Power Automate using XML Data.

 

Like the automated creation of records from XML, Power Automate can be used for several other use cases with the right insights and expertise
Explore more use cases at Inogic- Professional Services. Contact us at crm@inogic.com to enable business transformation now!