Building Dynamic XML/JSON content

[u4jaanus]

Hi,

Tricky one.

I have created a flow which for SOAP requests which is working fine.. however I have a need of adding dynamic content in the body of that flow. I cannot do that in Power Automate as Body Tag does not support dynamic data.

I am trying to create my xml request in PowerApp which then could be passed as whole in Body of my SOAP request via variable.

Could you please advise if this is possible. Example XML is below. I want to create dynamic tags for <product>containing products from a collection?

<sRequest xsi:type="xsd:string"><![CDATA[<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
                                <kmsgsimple id='' password=''>
                                <account>AM10</account>
                                <product mode='productlist' maxrecs='' page=''></product>
                                <branch>01</branch>
                                <productlist>
                                <product>DYNAMIC</product>
                                <product>DYNAMIC</product>
                                <product>DYNAMIC</product>
                                <product>DYNAMIC</product>
                                <product>DYNAMIC</product>
...
                                <pricesasatdate>DYNAMIC CURRENT DATE</pricesasatdate>
                                </productlist>
                                </kmsgsimple>]]>
         </sRequest>

Thank you

[StevePenner]

Can you adapt this to your needs: Call HTTP Request from a Canvas Power App using Flow and get back Response | Power Automate 

Is using SOAP markup required? Isn't using a REST API easier?

[u4jaanus]

Hi

unfortunately; my data source only support, SOAP with wsdl, cant do http calls :(.

i have solved the problem and will post solution later; I am now stuck in a new problem 🙂

thank you