how to view results from logic apps "Execute a sql query" connected to azure sql server

Rao Pokuru 0 Reputation points
2024-08-30T20:46:30.9333333+00:00

I am creating logical apps flow - which connects to azure sql server, runs a simple query with no parameters, then email results to my gmail.com

is there any example i can follow ?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,087 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. hossein jalilian 6,440 Reputation points
    2024-08-30T21:51:06.3666667+00:00

    Thanks for posting your question in the Microsoft Q&A forum.

    Create a new Logic App in the Azure portal, start with a blank Logic App or use the "Recurrence" trigger if you want it to run on a schedule, and add a new step and search for "SQL Server" connector. Choose "Execute a SQL query (V2)", and add another step and search for "Gmail" connector. Choose "Send email (V2)".

    After running the query, the results will be available in the body('Execute_a_SQL_query_(V2)')?['resultsets']['Table1'] object.

    Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.