Convert text to array

(0) Share

Report

Posted on by martinav

3,340

I have this text:

{
 "row": 1, 
 "3898437847541636": "201013", 
 "8402037474912132": "JS75S PRV Dwg. 72784-2-1", 
 "1083688080435076": "", 
 "3796166086289284": "2017-01-10T14:54:30Z", 
 "8299765713659780": "neisler@kelsotech.com"
}

I need to convert this to an array. Just pasting it into a set array does not work. Please advise!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

martinav 3,340 on at

Like (0)

Report
Copy link

Link copied!
More information.

I post this into an append to array. Looks good, right? But, when I poop this into a Compose, it has all of the carriage returns in it. Why did the append function not error?? It should have made the text into a digestible format for an array variable, right?

This looks ok, i think?

This is the output from the Compose, using this variable as input.

["{\n \"row\": 1, \n \"3898437847541636\": \"201013\", \n \"8402037474912132\": \"JS75S PRV Dwg. 72784-2-1\", \n \"1083688080435076\": \"\", \n \"3796166086289284\": \"2017-01-10T14:54:30Z\", \n \"8299765713659780\": \"neisler@company.com\"\n}{\n \"row\": 2, \n \"3898437847541636\": \"201015\", \n \"8402037474912132\": \"JS75S316 General Arrg.\", \n \"1083688080435076\": \"\", \n \"3796166086289284\": \"2017-01-10T14:54:30Z\", \n \"8299765713659780\": \"neisler@company.com\"\n}{\n \"row\": 3, \n \"3898437847541636\": \"201017\", \n \"8402037474912132\": \"JS75S316 General Arrg. w/Flue\", \n \"1083688080435076\": \"\", \n \"3796166086289284\": \"2017-01-10T14:54:30Z\", \n \"8299765713659780\": \"neisler@company.com\"\n}{\n \"row\": 4, \n \"3898437847541636\": \"201020\", \n \"8402037474912132\": \"JS75L General Arrg.\", \n \"1083688080435076\": \"\", \n \"3796166086289284\": \"2017-01-10T14:54:30Z\", \n \"8299765713659780\": \"neisler@company.com\"\n}"]

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @martinav ,

The Append to Array variable action would see the text as string so the action would run successful with no issue.

Why are you want to convert the text to Array?

Do you want to get the value of the row and so on? If yes, you could take a try with the Parse JSON action:

Best regards,

Alice

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

Was this reply helpful? Yes No
martinav 3,340 on at

Like (0)

Report
Copy link

Link copied!

@v-alzhan-msft ,

I do that. What I was trying to show in the Compose is what is also happening in the ParseJSON. Its pushing through all of the characters, and not into a proper array. Whats the deal?

The input to the ParseJSON is the output of my append array variable. It sees it as text.

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

Like (0)

Report
Copy link

Link copied!

Hi @martinav ,

Could you please share a screenshot of the configuration of your flow?

Could you please take a try to create the flow as my screenshot?

Best regards,

Alice

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

Was this reply helpful? Yes No