Categories: Microsoft Flow

Nested arrays with a single item in Power Automate

This post is all about unnecessarily complicated data structures like nested arrays with a single item in them.

Nested arrays Example

How often do you see data like this coming out of an action in Microsoft Flow where an array has a single item with another array:

[
  [
    {
      "key1": "value 1",
      "key2": "value 2"
    },
    {
      "key1": "value 3",
      "key2": "value 4"
    }
  ]
]

So often I see people getting the following error:

InvalidTemplate. Unable to process template language expressions in action ‘Compose’ inputs at line ‘1’ and column ‘2469’: ‘The template language expression ‘items(‘Apply_to_each’)?[‘key1′]’ cannot be evaluated because property ‘key1′ cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.’.

What does this error mean?

Obviously, you only wanted to get the Key1’s value from the array and you start to think, why doesn’t this just work?

Did you notice in the data that there were two square brackets around the item?

In my case there will only be 1 array of arrays and therefore I can select just the first item. We need to have a look at my overall flow here.

The apply each is taking my nested array and the apply to each still has to handle the inner array.

Therefore rather than using outputs(‘Compose_2’) I could be using outputs(‘Compose_2’)[0] to get to my array of items. Alternatively, you can also use the first() function

first(outputs('Compose_2'))

Share
Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

Recent Posts

Create new group alert using Power Automate

Do you want to know when a new group has been created with for example…

3 days ago

Delegation Warnings in Power Apps

We have all seen them, Delegation Warnings, but what is delegation and how do you…

3 days ago

1 Top tip: PowerPlatformLearn.com and master the Power Platform within no time

It can be difficult to get started with the Power Platform, blogs help, training helps,…

1 week ago

Compare 2 Excel files using Power Automate

This is such a common scenario. You receive Excel files on a regular basis and…

2 weeks ago

Rename SharePoint folders using Power Automate in 2 easy steps

Have you ever wanted to rename SharePoint folders with Power Automate? REST API call to…

3 weeks ago

Read dates from Excel with Power Automate

To read dates from Excel files can be tricky, as Excel only give you the…

4 weeks ago
%%footer%%