Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Convert Array

(0) ShareShare
ReportReport
Posted on by 18

Hi, I have following Array

[
 "T223566^T335125^T311000^",
 "Testing1^Testing2^Testing^",
 "First^;^Third^",
 ";^tomorrow^3-D^"
]

And by spltting the list by "^" i want this array as following with

[
 {
 "Row1": "T223566",
 "Row2": "Testing1",
 "Row3": "First",
 "Row4": ";"
 },
 {
 "Row1": "T335125",
 "Row2": "Testing2",
 "Row3": ";",
 "Row4": "tomorrow"
 },
 {
 "Row1": "T311000",
 "Row2": "Testing",
 "Row3": "Third",
 "Row4": "3-D"
 }
]

 

How do i do this??

/Erik

  • Verified answer
    erikgran Profile Picture
    18 on at
    Re: Convert Array

    Thank you eliotcole!

    Thanks to your input "(I'd imagine that Select actions with a range() function in there will come in to it)" I was able to make it work2022-05-13 09_34_52-Edit your flow _ Power Automate.png

  • eliotcole Profile Picture
    4,255 Super User 2025 Season 1 on at
    Re: Convert Array

    I see, thanks.

    I don't have time to look at this now, but if no-one else has had a pop (I'd imagine that Select actions with a range() function in there will come in to it) I'll try tonight.

  • erikgran Profile Picture
    18 on at
    Re: Convert Array

    Row1, Row2, Row3 and Row4 are always static. I will always have input by set of 4 values.

    But I would like the "set" of values to be dynamic.
    Another Example 

    [
     "T331992^T344899^",
     "Example1^Example2^",
     ";^;^",
     "Today^tomorrow^"
    ]

     

    [
     {
     "Row1": "T331992",
     "Row2": "Example1",
     "Row3": ";",
     "Row4": "Today"
     },
     {
     "Row1": "T344899",
     "Row2": "Example2",
     "Row3": ";",
     "Row4": "tomorrow"
     }
    ]

     

  • eliotcole Profile Picture
    4,255 Super User 2025 Season 1 on at
    Re: Convert Array

    Do you only need to do this once? Or will this be a programmatical approach to future, similar, values?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1