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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,260)