Answered

Array into json

(1) Share

Report

Posted on by Aethyta

How do I convert this array (from append to array variable):

["email1", "email2", "email3"]

into this format:

[
{"address":"email1"},
{"address":"email2"},
{"address":"email3"}
]

I'm using an HTTP connector. The logic app was created and must have the above format for the recipient.
I tried using Join and/or append to array to insert the address: but each time I insert a double quotation in Join, it turns into \"

Categories:

Building flows

I have the same question (1)

All responses (5)

Answers (1)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (3)

Report

Hi

Super Simple, add a Select. In the From put your array (in my case I setup a Test Array variable and set it to what you had)

in the Key put address

in the value put the expression item()

And you get what you want as the output after this array, look at the output of the Select

Was this reply helpful? Yes No
Suggested answer

Aethyta on at

Like (1)

Report

I'm pretty sure I tried this the first time and it failed in logic app but its working now.

Was this reply helpful? Yes No
Aethyta on at

Like (1)

Report

Not sure why I cannot accept or mark @FLMike's answer but I tried select and it worked too. I was able to mark my other one. Also, @mention doesn't seem to work as well. Thank you @FLMike. I'll be sure to document it for next time I need to use this logic app.

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (2)

Report

Yeah I dont know why, but the system is ridiculous

I answer many hours or days before... but if someone else answers way later they show up first.. kinda a waste of my time lately really

Was this reply helpful? Yes No
Aethyta on at

Like (1)

Report

This is so weird. I tried marking @FLMike first response as an answer again and it didn't work again -- just kept the loading icon running in circle. But when I tried marking his last response, it took it immediately.

Was this reply helpful? Yes No