I am trying to setup a flow which will execute a stored procedure on my on prem SQL db and mail the results to a specific mail address.
I am very new to Flow and not sure how to set this up.
The SP on the SQL server works fine. No input required and results are returned.
I would like some help with how to format these results into a HTML table, and mail to someone.
Any pointers would be appreciated.
Can you show the detail of 'create HTML table'?
Hi @kevinsray,
You could add a "Create HTML table" action under the SQL Stored Procedure, and then put the output dyanmic content of the SQL Stored Procedure in the From field of the "Create HTML table" action, then you could send the html table in the email, the screenshot should as below:
Best regards,
Alice
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional