Power Platform Community Forum Thread Details

I have an XML input that includes a list of products, some of which are considered “main products” with variants, and others are standalone products.

I need to transform this XML data into a structured JSON format where each main product has an array of its variants, and standalone products are listed separately.

I know how to convert XML into JSON, but I’m unsure how to filter and organize data correctly to get the desired JSON output.

Any suggestions or step-by-step guidance would be greatly appreciated!

<?xml version="1.0" encoding="UTF-8"?>
<ProductCatalog>
    <Products>
        <Product>
            <ProductNo>1000516</ProductNo>
            <IsMainProduct>0</IsMainProduct>
            <MainProductNo></MainProductNo>
        </Product>
        <Product>
            <ProductNo>1001001</ProductNo>
            <IsMainProduct>0</IsMainProduct>
            <MainProductNo>H1001001</MainProductNo>
        </Product>
        <Product>
            <ProductNo>1001002</ProductNo>
            <IsMainProduct>0</IsMainProduct>
            <MainProductNo>H1001001</MainProductNo>
        </Product>
        <Product>
            <ProductNo>H1001001</ProductNo>
            <IsMainProduct>1</IsMainProduct>
            <MainProductNo></MainProductNo>
        </Product>
    </Products>
</ProductCatalog>

{
"product_data": [
    {
      "product_number": "H1001001",
      "variants": [
        {
          "product_number": "1001001"
        },
        {
          "product_number": "1001002"
        }
      ]
    },
    {
      "product_number": "1000516"
    }
]
}

Categories:

Building flows