Combine the output results of SQL Server into one.

[soooofunny]

Hey guys.

I'm in trouble. I need your help.
I have a Power Automate connector that connects to SQL Server.
The result is what I wanted.

If there are multiple results, they are in JSON format? The results are displayed in JSON format?
I don't know how to handle this.

[
  {
    "UserCode": "12345"
  },
  {
    "UserCode": "45678"
  },
  {
    "UserCode": "14785"
  }
]

The output looks like this, but I have to change the format to something like the following
I would like to send it by e-mail in the format below.

-------------------------------------------------------------

(I want it to appear like this in the body of the email)

12345

45678

14785

-------------------------------------------------------------

Can someone please tell me how to do this?
Thank you very much.

[gabibalaban · Accepted solution]

@soooofunny ,

You can use a string variable to get your values and iterate through the SQL results.

I used Parse Json action to simulate the JSON answer from SQL.

Hope it helps !

[soooofunny]

Hi, @gabibalaban 

I'm sorry I didn't understand your explanation.

I don't know how to parse JSON.

The rest of the time, I mimicked your answers.

Thanks.

[gabibalaban]

@soooofunny 

You don’t need the parse JSON action, the SQL query result is received as JSON. All you have to do is to initialize a string variable, to use an Apply to each action to body (‘SQL action’) and inside it an Append to string variable (the initialized variable).

[soooofunny]

@gabibalaban 

I understood, to a point.
Is the content like the captured image correct?

I was able to put them one by one into the test2 variable, but if I want to combine them into one, how can I do that?

Thanks.

[soooofunny]

@gabibalaban 

I'm so sorry.

I guess I was very wrong.

The way you taught me, the variables were neatly packed into one.

I am very grateful to you.

Thanks.