How do you split items inside an array?

(1) Share

Report

Posted on by Morke

I have a single string which I need to split two times.

I have no issues splitting it the first time like this way:

String: "0;1;2; | a;b;c; | A;B;C; |"

Action: Initiate Variable

Name: varArray

Type: Array

Action: Set Variable

Input: varArray

Value: split('string','|')

Output:

[

"0;4;Premium SSD;",

"1;4;Premium SSD;",

"2;4;Premium SSD;",

"3;4;Premium SSD;",

]

Now, how do I further split each item of the array, producing an array of arrays?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-bacao-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @Morke ,

Please check the following configuration and see if it helps:

We could use items('Apply_to_each') to get the item of the array and continue to use split() function to handle it.

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
Morke 62 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the help. This works.
I have a doubt, what's the reference to "items()"? I want to understand how it works.
Also:
How can I use all the resulting split strings? I mean how do I use them as objects further down in the flow after this split? What's the reference to them?

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Morke ,

The Split() function will return an array. We generally use Apply to each to traverse the elements in the array, and the items() function is used to get the elements of each traversal.

If the element is an object, then we can get the property value through items()[‘PropertyName’].

You can use Apply to each to get each element and apply it to other actions, but the action must also be configured in Apply to each.

In addition, since the return value is an array, we can use index to get the value of each element. Like: You can get the value of the first element in the array through split ('string', '|') [0].

For more details, please refer to WDL function:

By doing more tests, we can easily master Data operations in Power Automate.

Best Regards,

Was this reply helpful? Yes No
Mlimacher 3 on at

Like (0)

Report
Copy link

Link copied!

Nice and simple 👍

Was this reply helpful? Yes No
Jorn75 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bacao-msft
I'm just wondering how the flow should look after apply to each if I want to add these text to a mail. How can I append these text in a mail (or an approval flow).

Best regards Jorn

Best regards Jorn

Was this reply helpful? Yes No