How to Combine multiple JSON result into single value.

(0) Share

Report

Posted on by Learn2Live

How to combine two JSON Values into single value.

This one might be very simple for you guys but i am not able to figure this out.
Below example shows 2 values

I would like to combine them in to one value like this 2022-10-10 , 2022-10-11

I tried using appending the array value and still no luck

Any suggestions how to get this result - 2022-10-10 , 2022-10-11
Thank you

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (4)

Report

Try this.

Add a new Select action after your parse JSON action.

In the From field select from dynamic content the body from Parse JSON.

In the map section click the little button on the right hand side that says "Switch map to text mode"

In the map section from dynamic content choose Value (from Parse JSON).

Add a Compose action and use this expression:

join(body('Select'), ', ')

That should be it. Screenshot to make it clearer:

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No
Learn2Live 47 on at

Like (0)

Report

@Paulie78 Thank you, That almost solved the problem
My compose output looks like this now - {"Value":"2022-10-10"},{"Value":"2022-10-11"}

how do i remove the other values to get only the date...

Was this reply helpful? Yes No
Learn2Live 47 on at

Like (0)

Report

Tried using the replace function
(replace(outputs('Compose'),'"Value":',''),';',',')
& ended up with this output - {"2022-10-10"},{"2022-10-11"}
still not able to figure out how to remove the “parentheses” / "curly brackets"

Any suggestions

Was this reply helpful? Yes No
Learn2Live 47 on at

Like (0)

Report

Thanks @Paulie78
I was able to get this working from one of your previous suggestion.

replace(replace(outputs('withBrackets'), '["', ''), '"]', '')
https://powerusers.microsoft.com/t5/Building-Flows/Removing-brackets-from-a-Compose-Output/td-p/852590

Was this reply helpful? Yes No