{"id":5001,"date":"2020-12-22T16:21:23","date_gmt":"2020-12-22T10:51:23","guid":{"rendered":"https:\/\/opstree.com\/blog\/\/?p=5001"},"modified":"2020-12-22T16:33:45","modified_gmt":"2020-12-22T11:03:45","slug":"an-overview-of-logic-apps-with-its-use-cases","status":"publish","type":"post","link":"https:\/\/opstree.com\/blog\/2020\/12\/22\/an-overview-of-logic-apps-with-its-use-cases\/","title":{"rendered":"An Overview of Logic Apps with its Use Cases"},"content":{"rendered":"\r\n
\"See<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n

Azure Logic Apps is the PaaS (Platform as a Service) offering from Microsoft Azure. Logic Apps helps us to define workflows and build powerful solutions with the help of connectors, triggers, and actions.<\/p>\r\n

\u00a0Prerequisites<\/strong><\/p>\r\n\r\n\r\n\r\n

– Basic understanding of cloud platform and SQL Query.<\/p>\r\n

Let us understand this with a simple example:<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

<\/p>\r\n\r\n\r\n\r\n

Let’s suppose we want to receive an email as soon as there is a new tweet posted on Twitter, that solution can be established using Logic Apps (through connectors)<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

This is just a basic example. Similarly, many complex workflows can be established using Logic Apps.<\/p>\r\n\r\n\r\n\r\n

Another example can be that we can automatically fetch new records from a SQL database and then send email alerts to users.<\/p>\r\n\r\n\r\n\r\n

The good thing is that you don’t need to write a single line of code. Everything can be done using Logic Apps Designer in Azure Portal.<\/p>\r\n\r\n\r\n\r\n

As far as the cost is concerned, you only need to pay for the actions you execute in your logic apps. It follows the consumption pricing model.<\/p>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Use Case<\/strong><\/p>\r\n\r\n\r\n\r\n

In this demo use case, we will see how you can alert users based on the data present\/updated in your SQL Database.<\/p>\r\n\r\n\r\n\r\n

Step 1:<\/strong> Go to the Azure Portal. Fill in the required details and click ‘Review + create’ to create your Logic App.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 2:<\/strong> Go to the Azure Portal. Fill in the required details and click ‘Review + create’ to create your SQL Database.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 3: <\/strong>Go to the SQL Database and click ‘Query Editor’.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 4:<\/strong> Enter your credentials and you will get the following screen.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

NOTE: If you face the error listed below while logging in, then you need to whitelist your client IP in server firewall settings.<\/strong><\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 5:<\/strong> After you have opened the query editor, you need to run the below query. This query will create a table named ‘Alerts<\/strong>‘.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

You can verify the same in tables. A new table named ‘dbo.Alerts’ will be created.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step 6:<\/strong> Insert records into the Alerts table using the query listed below.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

(For demo purpose, I am sending 3 mails to my mail address with different subject and body)<\/p>\r\n\r\n\r\n\r\n

Step 7:<\/strong> Run the query listed here and verify that the records have been inserted into the table.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 8:<\/strong> Go back to the portal and open blank Logic App.<\/p>\r\n\r\n\r\n\r\n

From here, we start configuring our Logic App.<\/p>\r\n\r\n\r\n\r\n

Step 9:<\/strong> We will use a Recurrence Trigger (Logic App will run automatically at the defined schedule)<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 10: <\/strong>Add a new step named ‘SQL Server’. We will use ‘Get Rows’ as action.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step 11:<\/strong> Enter the credentials (In background, connectors are getting created). Enter your server name (FQDN), database name, username and password.<\/p>\r\n\r\n\r\n\r\n

Step 12:<\/strong> Add a new step ‘For-Each’ in the Logic App.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 13:<\/strong> Select ‘Value’ Parameter from Dynamic Content.<\/p>\r\n\r\n\r\n\r\n

(Reason for selecting this is we want to fetch each value from previous step and then send email for these values)<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 14:<\/strong> Now add a ‘Send mail’ Action as below.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 15: <\/strong>Enter the details from Dynamic content. We will not be doing hard-coding \ud83d\ude42<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

Step 16:<\/strong> Finally SAVE the Logic App.<\/p>\r\n\r\n\r\n\r\n

Step 17:<\/strong> Wait for sometime and you will receive an email.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

This is how you can create a workflow with the help of Logic Apps. You can play around with it and try adding one more row into the SQL Database. You would receive a mail for that too.<\/p>\r\n\r\n\r\n\r\n

Happy Learning \ud83d\ude42<\/p>\r\n

Image Source<\/a><\/p>\r\n

 <\/p>\r\n

Opstree is an End to End DevOps solution provider<\/p>\r\n

\r\n\r\n<\/p>\r\n

CONTACT US<\/a><\/p>\r\n","protected":false},"excerpt":{"rendered":"

  Azure Logic Apps is the PaaS (Platform as a Service) offering from Microsoft Azure. Logic Apps helps us to define workflows and build powerful solutions with the help of connectors, triggers, and actions. \u00a0Prerequisites – Basic understanding of cloud platform and SQL Query. Let us understand this with a simple example:<\/p>\n","protected":false},"author":197679939,"featured_media":29900,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[28070474],"tags":[223461147,69816,230405003,12793557],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/11\/DevSecOps-1.jpg","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pfDBOm-1iF","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/5001"}],"collection":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/users\/197679939"}],"replies":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/comments?post=5001"}],"version-history":[{"count":25,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/5001\/revisions"}],"predecessor-version":[{"id":5182,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/5001\/revisions\/5182"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media\/29900"}],"wp:attachment":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media?parent=5001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/categories?post=5001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/tags?post=5001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}