Convert Array of Objects to Object of Objects

[PowerAutomate15]

Hello,

I see a lot of applications are suppling array of objects with a key inside the object. 

It is imposable to know the position of the object I'm looking for in the array.

When I want to use those objects further, I always use filter array actions based on those keys.

Sometimes I have to use lots of fitter array actions in order to get to all the objects I need.  

For example 

DocuSign supplies an array of objects each tab filed is a separate object in the array. 

Smartsheet supplies an array of objects each cell in a row is a separate object.  

I wander if there is a way to manipulate those arrays of objects into an object of objects and set those keys inside the object to the key to the object instead of having same just as a number in an array. 

That way it will be supper easy to delegate through the output object and use in for input in further steps.

Current Output Array of Objects

{
    "body":{
        "recipientTabs":[
            {
                "name":"SignHere",
                "tabType":"signhere",
                "tabLabel":"Signature",
                "documentId":"1",
                "tabId":"1327bc1c3-4a14-4508-ab76-ae2fc85d04aa",
                "recipientId":"1"
            },
            {
                "name":"Test",
                "tabType":"Text",
                "tabLabel":"Test",
                "documentId":"1",
                "tabId":"42esf022-cc983-462a-8553-27e8383f3ac8",
                "recipientId":"1"
            }
        ]
    }
}

Desired Output Object of Objects

{
    "body": {
        "recipientTabs": {
            "1327bc1c3-4a14-4508-ab76-ae2fc85d04aa": {
                "name": "SignHere",
                "tabType": "signhere",
                "tabLabel": "Signature",
                "documentId": "1",
                "tabId": "1327bc1c3-4a14-4508-ab76-ae2fc85d04aa",
                "recipientId": "1"
            },
            "42esf022-cc983-462a-8553-27e8383f3ac8": {
                "name": "Test",
                "tabType": "Text",
                "tabLabel": "Test",
                "documentId": "1",
                "tabId": "42esf022-cc983-462a-8553-27e8383f3ac8",
                "recipientId": "1"
            }
        }
    }
}

 Thank you

[v-bofeng-msft · Accepted solution]

Hi @PowerAutomate15 ,

I've made a test for your  reference:

1)

variables('TheObj')['body']['recipientTabs']

2)

addProperty(outputs('Compose_2'),item()['tabId'],item())

3)

{
    "body": {
        "recipientTabs":@{variables('NewRecipientTabs')}
   }
}

Result

Best Regards,

Bof

[PowerAutomate15]

Hi @v-bofeng-msft,

I have tested your solution, and it works like a charm.

After playing some time I found another way to accomplish this without looping through the whole array, but I can't complete it.

Maybe you can help me finish up this concept.

Here is what I did.

I used the Select action. 

From @{variables('array')}

Map Key @{item()?['tabLabel']} Value @{item()}

The output is an array of objects each object has 1 object with the desired output.

Like this.

Current Output Array of Objects of Objects

[
    {
      "Signature1": {
        "name": "SignHere",
        "tabType": "signhere",
        "tabLabel": "Signature1",
        "documentId": "1",
        "tabId": "1327cb1c3-4a14-45bb08-ab76-ae2fcb85d04aa",
        "recipientId": "1"
      }
    },
    {
      "Signature2": {
        "name": "SignHere",
        "tabType": "signhere",
        "tabLabel": "Signature2",
        "documentId": "1",
        "tabId": "42e4ad022-c983-4dc62a-8553-27ev8383f3ac8",
        "recipientId": "1"
      }
    }
  ]

Now I'm looking for a way to remove the first 2 layers, the array layer and the object layer and stay just with 1 object with multipole objects inside.

Or we can say I'm looking to convert the first array to an object.

Desired Output Object of Objects

    {
      "Signature1": {
        "name": "SignHere",
        "tabType": "signhere",
        "tabLabel": "Signature1",
        "documentId": "1",
        "tabId": "1327cb1c3-4a14-45bb08-ab76-ae2fcb85d04aa",
        "recipientId": "1"
       },  
      "Signature2": {
        "name": "SignHere",
        "tabType": "signhere",
        "tabLabel": "Signature2",
        "documentId": "1",
        "tabId": "42e4ad022-c983-4dc62a-8553-27ev8383f3ac8",
        "recipientId": "1"
      }
    }

Thank you