Microsoft Power Automate Tutorials || Module 37 : Expressions - JSON and XML Conversion Function

<?xml version="1.0" encoding="UTF-8"?><orders><order><Order_ID><![CDATA[312]]></Order_ID><Order_Status><![CDATA[Awaiting Fulfillment]]></Order_Status><Order_Date><![CDATA[22/11/2021]]></Order_Date><Subtotal_ex_tax><![CDATA[48.90]]></Subtotal_ex_tax><Tax_Total><![CDATA[4.89]]></Tax_Total><Shipping_Cost_ex_tax><![CDATA[0.00]]></Shipping_Cost_ex_tax><Order_Total_inc_tax><![CDATA[53.79]]></Order_Total_inc_tax><Order_Total_ex_tax><![CDATA[48.90]]></Order_Total_ex_tax><Total_Quantity><![CDATA[1]]></Total_Quantity><Total_Shipped><![CDATA[0]]></Total_Shipped><Date_Shipped><![CDATA[]]></Date_Shipped><Order_Notes><![CDATA[]]></Order_Notes><Customer_Message><![CDATA[remove fax number, change email address to: service@blackwooddyno.com.au]]></Customer_Message><Billing_First_Name><![CDATA[Blackwood Dyno Tune & Service]]></Billing_First_Name><Billing_Last_Name><![CDATA[336]]></Billing_Last_Name><Billing_Street_1><![CDATA[2 Stirling Road]]></Billing_Street_1><Billing_Street_2><![CDATA[]]></Billing_Street_2><Billing_Suburb><![CDATA[Blackwood]]></Billing_Suburb><Billing_State_Abbreviation><![CDATA[SA]]></Billing_State_Abbreviation><Billing_Zip><![CDATA[5051]]></Billing_Zip><Billing_Phone><![CDATA[]]></Billing_Phone><Billing_Email><![CDATA[service@blackwooddyno.com.au]]></Billing_Email><Customer_Group_Name><![CDATA[Premium]]></Customer_Group_Name><Product_Details><item><Product_ID><![CDATA[203]]></Product_ID><Product_Qty><![CDATA[1]]></Product_Qty><Product_SKU><![CDATA[RP30]]></Product_SKU><Product_Name><![CDATA[Logbook Stamp]]></Product_Name><Product_Variation_Details><![CDATA[]]></Product_Variation_Details><Product_Unit_Price><![CDATA[48.90]]></Product_Unit_Price><Product_Unit_Cost><![CDATA[0.00]]></Product_Unit_Cost></item></Product_Details><Transaction_ID><![CDATA[]]></Transaction_ID></order><order><Order_ID><![CDATA[313]]></Order_ID><Order_Status><![CDATA[Awaiting Fulfillment]]></Order_Status><Order_Date><![CDATA[22/11/2021]]></Order_Date><Subtotal_ex_tax><![CDATA[322.50]]></Subtotal_ex_tax><Tax_Total><![CDATA[32.25]]></Tax_Total><Shipping_Cost_ex_tax><![CDATA[0.00]]></Shipping_Cost_ex_tax><Order_Total_inc_tax><![CDATA[354.75]]></Order_Total_inc_tax><Order_Total_ex_tax><![CDATA[322.50]]></Order_Total_ex_tax><Total_Quantity><![CDATA[8]]></Total_Quantity><Total_Shipped><![CDATA[0]]></Total_Shipped><Date_Shipped><![CDATA[]]></Date_Shipped><Order_Notes><![CDATA[]]></Order_Notes><Customer_Message><![CDATA[]]></Customer_Message><Billing_First_Name><![CDATA[Halls Gully Automotive]]></Billing_First_Name><Billing_Last_Name><![CDATA[447]]></Billing_Last_Name><Billing_Street_1><![CDATA[Factory 1 / 35 Clyde Street]]></Billing_Street_1><Billing_Street_2><![CDATA[]]></Billing_Street_2><Billing_Suburb><![CDATA[Ferntree Gully]]></Billing_Suburb><Billing_State_Abbreviation><![CDATA[VIC]]></Billing_State_Abbreviation><Billing_Zip><![CDATA[3156]]></Billing_Zip><Billing_Phone><![CDATA[]]></Billing_Phone><Billing_Email><![CDATA[hallsgullyauto@bigpond.com]]></Billing_Email><Customer_Group_Name><![CDATA[Authorised]]></Customer_Group_Name><Product_Details><item><Product_ID><![CDATA[112]]></Product_ID><Product_Qty><![CDATA[2]]></Product_Qty><Product_SKU><![CDATA[RPOLO-L]]></Product_SKU><Product_Name><![CDATA[Poly Cotton Polo Shirt]]></Product_Name><Product_Variation_Details><![CDATA[Size: Large, Extra Decoration: Staff Name+ Business name, Details: Damien ]]></Product_Variation_Details><Product_Unit_Price><![CDATA[36.90]]></Product_Unit_Price><Product_Unit_Cost><![CDATA[0.00]]></Product_Unit_Cost></item><item><Product_ID><![CDATA[112]]></Product_ID><Product_Qty><![CDATA[3]]></Product_Qty><Product_SKU><![CDATA[RPOLO-M]]></Product_SKU><Product_Name><![CDATA[Poly Cotton Polo Shirt]]></Product_Name><Product_Variation_Details><![CDATA[Size: Medium, Extra Decoration: Staff Name+ Business name, Details: Michael]]></Product_Variation_Details><Product_Unit_Price><![CDATA[36.90]]></Product_Unit_Price><Product_Unit_Cost><![CDATA[0.00]]></Product_Unit_Cost></item><item><Product_ID><![CDATA[289]]></Product_ID><Product_Qty><![CDATA[2]]></Product_Qty><Product_SKU><![CDATA[RTJP-L]]></Product_SKU><Product_Name><![CDATA[Polyester Technician Jumper]]></Product_Name><Product_Variation_Details><![CDATA[Size: L, Embroidery: Staff Member Name+ Business Name, Details: Damien]]></Product_Variation_Details><Product_Unit_Price><![CDATA[46.00]]></Product_Unit_Price><Product_Unit_Cost><![CDATA[0.00]]></Product_Unit_Cost></item><item><Product_ID><![CDATA[289]]></Product_ID><Product_Qty><![CDATA[1]]></Product_Qty><Product_SKU><![CDATA[RTJP-M]]></Product_SKU><Product_Name><![CDATA[Polyester Technician Jumper]]></Product_Name><Product_Variation_Details><![CDATA[Size: M, Embroidery: Staff Member Name+ Business Name, Details: Michael]]></Product_Variation_Details><Product_Unit_Price><![CDATA[46.00]]></Product_Unit_Price><Product_Unit_Cost><![CDATA[0.00]]></Product_Unit_Cost></item></Product_Details><Transaction_ID><![CDATA[]]></Transaction_ID></order></orders>

@Ameer  when i bring in XML  i get <!CDATA[ my text]]>   and when i try to parse xml to json cannot use the outputs  ans i get "#cdata-section": "968"  in my flow  out puts booth the "#cdata-section" and the Output listed both return NULL values?  or even  dissapear all together  and all i see in flow  outputs is  "TYPE TYPE TYPE TYPE"