Create a String from an Array

(0) Share

Report

Posted on by johnjohnPter

2,074 Season of Giving Solutions 2025

I have those 2 actions, one to Select the IDs of SharePoint Items, and one to build a semi-collon separated string from the array:-

now the results of the first action is a valid array, but the result of the Compose will be weired:-

where the result will be {"ID":1250} ... while i were planning to have 1250;

Any advice?

Categories:

Building flows

All responses (4)

Answers (0)

Sort by

Suggested answer

bscarlavai33 810 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

There might be a fancier way but one way that will definitely work is to initialize an array variable called "Output" or something similar and then loop through the output of your "SelectAllNetworkIDs" compose. Within the loop, use an "Append to array" against "Output" and use the expression

items('Apply_to_each')['ID'].

Finally, after the loop, use a Compose with the join expression.

I tested it and I get the result you're looking for.
johnjohnPter 2,074 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@@bscarlavai33 i always try to avoid applytoeach as it is slow and consume a lot of requests.. i think using a Select should work, but not sure what i am doing wrong
bscarlavai33 810 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah I get that. Its usually not terrible if you're only doing transformations inside the loop and you have it using concurrency.

The problem with Select is that it always returns an object and you just want a single value from each object. I'm not aware of a way to get multiple values from multiple objects at once without using a loop but someone might have a way.
Suggested answer

David_MA 15,528 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

You want to set it up like below. For the Select action, switch it to Map mode.

The expression in the Compose action is join(body('Select'),'; ')

Your output will be as shown below if I understand your goal correctly: