Unanswered

Write email after Executing a SQL query (via on-prem Gateway) for Recurring flow

(1) Share

Report

Posted on by janineb

Good day

I have a recurring flow that tests every day whether it is the beginning of the month. If so, it extracts data from a SQL Stored Procedure to see which contracts are in "Follow Up" status. It then must send an email to the Procurement officer to warn him that this contract is coming up for renewal. Everything works fine up to the point that I run the SQL stored procedure. I need to get the data from the stored procedure and use that to send emails. However, I am stuck. Can you please help me to complete the flow, starting after the "Executing the SQL query"?

Thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @janineb

What is wrong with what you have?

Was this reply helpful? Yes No
janineb on at

Like (1)

Report
Copy link

Link copied!

Hi

Thank you for your response. This is the error I'm getting

Was this reply helpful? Yes No
Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

Thanks @janineb

In the future remember to include the things necessary to debug, it saves those helping you a lot of time and gets you resolved faster.

So the issue is you picked the output of the Compose, which is an Object, what we need to do is convert that to an Array.

Can you please explain do the following

1. Share the Output of the Compose here, that way I can see the format.

2. Tell me exactly what data you want out of the Compose so that I can find the proper Path of data to convert what you are giving it from an Object to an Array

Thanks

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
janineb on at

Like (1)

Report
Copy link

Link copied!

Thank you so much Michael, it worked perfectly. I appreciate your guidance on providing all the info.

I changed the Condition (Apply to each) to: array(triggerOutputs()?['body'])
This was my Output:
The last thing I would like assistance with is the Email please:

How can I populate the fields next to each "Heading" with the information in the database (Output example above - blue text). This is the only options available under the Dynamic content.

Much appreciated

Was this reply helpful? Yes No
janineb on at

Like (1)

Report
Copy link

Link copied!

This is the current output from the email
{
"statusCode": 200,
"headers": {
"Cache-Control": "no-store, no-cache",
"Pragma": "no-cache",
"Set-Cookie": "ARRAffinity=f2b03ea959f8416bc6b71d28a36cf8c0479d848b33638ccc3ef4c51389285d81;Path=/;HttpOnly;Secure;Domain=office365-we.azconn-we-002.p.azurewebsites.net,ARRAffinitySameSite=f2b03ea959f8416bc6b71d28a36cf8c0479d848b33638ccc3ef4c51389285d81;Path=/;HttpOnly;SameSite=None;Secure;Domain=office365-we.azconn-we-002.p.azurewebsites.net",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"x-ms-request-id": "76b78438-e40a-7fdc-4f21-d8c64955d20f",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"x-ms-environment-id": "default-b4e5483d-e090-4a58-b1cf-fbaa0ec4beb5",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Sun, 07 Jul 2024 11:35:13 GMT",
"Content-Length": "0",
"Expires": "-1"
}
}

Was this reply helpful? Yes No