cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
soooofunny
Helper II
Helper II

Combine the output results of SQL Server into one.

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.

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Dual Super User
Dual Super User

@soooofunny ,

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

 

gabibalaban_0-1624103471956.png

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

 

Hope it helps !

View solution in original post

5 REPLIES 5
gabibalaban
Dual Super User
Dual Super User

@soooofunny ,

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

 

gabibalaban_0-1624103471956.png

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

 

Hope it helps !

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.

34321.png

Thanks.

@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).

@gabibalaban 

 

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

 

165803.png

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.

@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.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,325)