Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Mail Results of SQL Stored Procedure using Flow

(0) ShareShare
ReportReport
Posted on by 209

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.

  • jwheadrick Profile Picture
    4 on at
    Re: Mail Results of SQL Stored Procedure using Flow

    Can you show the detail of 'create HTML table'?

  • v-yuazh-msft Profile Picture
    on at
    Re: Mail Results of SQL Stored Procedure using Flow

    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:

    Capture.PNG

     

    Best regards,

    Alice

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow