Power Platform Community Forum Thread Details

Hi there,

I have a Json structure like that

[
{
"ColumnID": "1",
"Column1": "Main directory1",
},

{
"ColumnID": "2",
"Column1": "Main directory2",
},

{
"ColumnID": "3",
"Column1": "Main directory3",

},
]

I would like to iterate through it so that at each iteration I read the following values:

{
"1": "Main directory1",

"2": "Main directory2",

"3": "Main directory3",
}

Categories:

Building flows

You could try the following method:

The Select action produces the following array:

[
  {
    "1": "Main directory1"
  },
  {
    "2": "Main directory2"
  },
  {
    "3": "Main directory3"
  },
  {
    "4": "Main directory4"
  },
  {
    "5": "Main directory5"
  },
  {
    "6": "Main directory6"
  },
  {
    "7": "Main directory7"
  },
  {
    "8": "Main directory8"
  },
  {
    "9": "Main directory9"
  },
  {
    "10": "Main directory10"
  },
  {
    "11": "Main directory11"
  },
  {
    "12": "Main directory12"
  }
]

Finally I use some string manipulation to change the array into an object:

json(replace(slice(string(body('Select')), 1, -1), '},{', ','))

This is the output:

Finally I test the newly created object by attempting to reference property 10:

outputs('Compose')?['10']

I expect the result to be "Main directory10"

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Community site session details

Convert JSON array to different array format

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates