Skip to main content
Community site session details

Community site session details

Session Id : HKdP5g0v84/xSidprc3biu
Power Automate - Building Flows
Answered

How to Combine multiple JSON result into single value.

Like (0) ShareShare
ReportReport
Posted on 7 Oct 2022 04:54:08 by 45

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 

Learn2Live_0-1665117390659.png

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 

Learn2Live_1-1665118327727.png

 

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

  • Learn2Live Profile Picture
    45 on 08 Oct 2022 at 02:33:18
    Re: How to Combine multiple JSON result into single value.

    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

  • Learn2Live Profile Picture
    45 on 08 Oct 2022 at 01:10:03
    Re: How to Combine multiple JSON result into single value.

    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 

     

  • Learn2Live Profile Picture
    45 on 07 Oct 2022 at 15:34:40
    Re: How to Combine multiple JSON result into single value.

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

    Learn2Live_0-1665156774577.png

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

  • Verified answer
    Paulie78 Profile Picture
    8,416 Moderator on 07 Oct 2022 at 06:07:20
    Re: How to Combine multiple JSON result into single value.

    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:

    Join.png

     

    Blog: tachytelic.net

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

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2