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.