cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Re-location the Character with string

Hi Everyone,

 

I know how to collect the data used "apply to each" and transfer String to the Array, like this:

 

Data:

Capture_string.JPG

 

 

Result:

Capture_string2.JPG

 

 

This time, I need to re-location the data in the string, and use apply to each to the further application:

 

The original data:

[

[

"54573",

"AB",

"",

"40",

"U18",

"Dd",

"Dd",

"522",

"4KP",

"4HP"

],

[

"2345",

"KC",

"",

"43",

"U28",

"Dd",

"Dd",

"533",

"4KP",

"4HP"

]

]

Transfer to the result:

[

[

"40",

"",

"U18",

"4KP",

"522"

],

[

"43",

"",

"U28",

"4KP ",

"533"

]

]

 

I already use apply to each and set variable:

[item()[3], item()[2], item()[4], item()[8], item()[7]]

But the data collection used Append to string will become :

[["40","","U18","4KP","522"]["43","","U28","4KP ","533"]

And can't used in Apply to each for further application, even use  @{replace(variables('Re_arrange header_2'), '][', '],[')}

 

While used Append to Array, it has to be {"AB": item()[3], "BC": item()[2].............}

Capture-string3.JPG

 

I stunk in here a few days, can somebody help me or give me the tips? Thanks

 

Regards,

ilu989

1 ACCEPTED SOLUTION

Accepted Solutions

 

Hi @ilu989 ,

 

Please use this method. Import Flow and test it.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Community Support
Community Support

 

Hi @ilu989 ,

 

I want to confirm your needs first. Is every element in the array also an array? It seems more reasonable here if it is Object.

I tried on my side according to the data you provided, but the results did not seem to be very good. The final result cannot be used by Apply to each. Because it is a string, it cannot be converted to an array.

Please import the flow in the attachment, and then see the specific steps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-bacao-msft ,

 

Thanks for your reply!

I need the Array to be used in the Apply to each!

The String can not be applied to the further Apply to each:

Do you have any other way to overcome this situation? Thanks

 

Capture-string4.JPG

Regards,

ilu989

 

Hi @ilu989 ,

 

I'm trying, but if the array elements are also arrays, it seems like a difficult situation to deal with.🤔

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi @ilu989 ,

 

Please use this method. Import Flow and test it.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @v-bacao-msft ,

 

Thanks for the support! It let me eye-opener and learns the new method to use Apply to each and output expression, thanks again!

 

ilu989

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Kudoed Authors
Users online (35,565)