Creating a 2D Array

(0) Share

Report

Posted on by Nevwhile

Hi all, first ever post so please be gentle.

I am looking to use Power Automate to get some data that is in SharePoint to populate a word document.

Basic mapping of SP single column values to document placeholders is fairly easy, however my challenge is that the data I have is a multi delimited string.

In this format.

1;2;3;|4;5;6;|7;8;9;

This is data that originates from a repeating section in a canvas app.

I need to get it into a 2D Array in order to populate a repeating table using the populate Word template connector in Power Automate.

Something like this:-

[

{

"Value1": "1",

"Value2": "2",

"Value3": "3",

{

"Value1": "4",

"Value2": "5",

"Value3": "6",

{

"Value1": "7",

"Value2": "8",

"Value3": "9",

}

]

Currently struggling with it and under pressure to get a solution.

I'm not a seasoned developer so any help would be greatfully appreciated.

Kind Regards

Neil

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Nevwhile

I hope this would work for you

So here i am storing the string data in a compose action for demo purposes.

For spliting into a array format as you require, first i will split it using | as delimiter and pass that to input of select action as shown above. Now we will be using splitting indiviual items from the iteration based on semi colon and then taking 1st,2nd and 3rd values respectuvley and assigning it to Value1, Value2, Value3 key respectively as shown below

Output will be like this :

you can further use the output from select action to perform your tasks 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

1 people found this reply helpful.

Was this reply helpful? Yes No
Nevwhile 6 on at

Like (0)

Report

Hi there @Nived_Nambiar
That has worked perfectly. I cannot thank you enough for such a speedy response. All kudos to you sir.👍
Kind Regards
Neil

Was this reply helpful? Yes No