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.
Solved! Go to Solution.
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 !
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 !
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.
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).
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.
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
26 | |
25 | |
24 | |
23 | |
21 |
User | Count |
---|---|
61 | |
42 | |
41 | |
29 | |
25 |