Logic Apps Data Mapper Loop

PABITRA KUMAR PATRA 0 Reputation points
2025-09-11T07:08:31.0266667+00:00

I'm currently working with the new Logic Apps Data Mapper and I'm trying to replicate functionality similar to the old Looping Functoid from the BizTalk Mapper.

In my scenario:

  • The source schema is JSON and contains a single array.
  • The destination schema has an array that contains a nested array, which is where I need to map the values from the source.

However, I'm facing a challenge: Logic Apps Data Mapper doesn't seem to support a direct equivalent of the Looping Functoid, and when I try to map the source array directly to the nested destination array, it results in duplicated values or incorrect nesting.

Input Json Structure:

{
  "Materials": [
    {
      "MaterialNo": "MAT001",
      "Price": 100
    },
    {
      "MaterialNo": "MAT002",
      "Price": 200
    }
  ]
}

Expected Output Json Structure:

{
  "Materials": [
    {
      "Material": "MAT001",
      "PriceSet": [
        {
          "Price": 100
        }
      ]
    },
    {
      "Material": "MAT002",
      "PriceSet": [
        {
          "Price": 200
        }
      ]
    }
  ]
}

But Getting output as below:

{
  "Materials": [
    {
      "Material": "MAT001",
      "PriceSet": [
        {
          "Price": 100
        },
        {
          "Price": 200
        }
      ]
    },
    {
      "Material": "MAT002",
      "PriceSet": [
        {
          "Price": 100
        },
        {
          "Price": 200
        }
      ]
    }
  ]
}

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.