Convert Multiple String with different values to JSON

(0) Share

Report

Posted on by sarahairis

Hi everyone,

Do you know how to convert a string like below

[

"Product: A",

"Quantity: 2",

"Order Start Date: 21/3/2023",

"Order Term (Month): 4",

"",

"Product: B",

"Quantity: 10",

"Order Start Date: 21/7/2023",

"Order Term (Month): 12"

]

to something like JSON like below,

[

{"Product": "A"},

{"Quantity": "2"},

{"Order Start Date": "21/3/2023"},

{"Order Term (Month)": "4"},

{"Product": "B"},

{"Quantity": "10"},

{"Order Start Date": "21/7/2023"},

{"Order Term (Month)": "12"}

]

I want this output to parse in JSON and store in sharepoint list.

Categories:

Building flows

I have the same question (1)

All responses (5)

Answers (0)

Sort by

grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Will there always be 4 properties for each item?

Product

Quantity

Order Start Date

Order Term (Month)

Based on that assumption, this will hopefully get what you're looking for.

See full flow below. I'll go into each of the actions.

Compose contains your data.

Filter array removes the empty items. It uses the following expression.

trim(item())

Select uses the following expressions to build up each of the objects.

//From (will get 4 items from your array at a time) chunk(body('Filter_array'), 4) //Map - keys trim(first(split(item()[0], ':'))) trim(first(split(item()[1], ':'))) trim(first(split(item()[2], ':'))) trim(first(split(item()[3], ':'))) //Map - values trim(last(split(item()[0], ':'))) trim(last(split(item()[1], ':'))) trim(last(split(item()[2], ':'))) trim(last(split(item()[3], ':')))

After running the flow, we would get the following output.

[ { "Product": "A", "Quantity": "2", "Order Start Date": "21/3/2023", "Order Term (Month)": "4" }, { "Product": "B", "Quantity": "10", "Order Start Date": "21/7/2023", "Order Term (Month)": "12" } ]

Was this reply helpful? Yes No
sarahairis on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @grantjenkins ,

I forgot to put "Order End Date", I tried to make modified Select

//From (will get 4 items from your array at a time) chunk(body('Filter_array'), 5) //Map - keys trim(first(split(item()[0], ':'))) trim(first(split(item()[1], ':'))) trim(first(split(item()[2], ':'))) trim(first(split(item()[3], ':'))) trim(first(split(item()[4], ':'))) //Map - values trim(last(split(item()[0], ':'))) trim(last(split(item()[1], ':'))) trim(last(split(item()[2], ':'))) trim(last(split(item()[3], ':'))) trim(last(split(item()[4], ':')))

but I got an error below,

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you confirm that you used is not equal to in the Filter array? It looks like no data is coming through.

If you do already have that filter as shown above - can you show the output you are getting from your Filter array when you run the flow.

Was this reply helpful? Yes No
sarahairis on at

Like
a
(0)

Report
Copy link

Link copied!

@grantjenkins ,

Yes, I leave it blank,

this is the output,

Was this reply helpful? Yes No
sarahairis on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @grantjenkins ,

When I use
chunk(body('Filter_array'), 4)
or
chunk(body('Filter_array'), 6)
there is no error but I will not get 5 properties in each item in order. That's strange, I don't know what's the root cause of it.

Was this reply helpful? Yes No