You’re offline. This is a read only version of the page.
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
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
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
@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...
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 😘
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
