Logic Apps for visual workflows in Azure - Mini Project: Build & Apply

Logic Apps for Visual Workflows

📖 Scenario: You work in a small company that wants to automate sending a welcome email to new employees. Instead of writing code, you will use Azure Logic Apps to create a visual workflow that triggers when a new employee is added to a SharePoint list.

🎯 Goal: Create a Logic App that triggers on a new SharePoint list item, extracts the employee's name and email, and sends a welcome email automatically.

📋 What You'll Learn

Create a Logic App with a trigger for new SharePoint list items

Add an action to get the employee's name and email from the list item

Add an action to send an email using Office 365 Outlook

Configure the email with a subject and body including the employee's name

💡 Why This Matters

🌍 Real World

Automating business processes without writing code saves time and reduces errors. Logic Apps provide a visual way to connect services like SharePoint and Outlook.

💼 Career

Cloud architects and developers use Logic Apps to build scalable, maintainable workflows that integrate multiple cloud services efficiently.

1

Create the Logic App trigger for new SharePoint list items

In your Logic App designer, create a trigger using When an item is created from the SharePoint connector. Set the Site Address to https://contoso.sharepoint.com/sites/employees and the List Name to NewEmployees.

Azure

# Add the SharePoint trigger with Site Address and List Name
# Your code here

Need a hint?

Use the SharePoint connector trigger named When an item is created and set the site URL and list name exactly as given.

2

Add actions to extract employee name and email

Add an action to get the employee's Name and Email from the SharePoint list item. Use the dynamic content from the trigger to select Name and Email fields.

Azure

{
  "definition": {
    "triggers": {
      "When_an_item_is_created": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connection": {
              "name": "/subscriptions/{subscription-id}/resourceGroups/{resource-group}/providers/Microsoft.Web/connections/sharepoint"
            }
          },
          "method": "get",
          "path": "/datasets/default/tables/NewEmployees/onnewitems",
          "queries": {
            "siteUrl": "https://contoso.sharepoint.com/sites/employees",
            "listName": "NewEmployees"
          }
        },
        "recurrence": {
          "frequency": "Minute",
          "interval": 3
        }
      }
    },
    "actions": {
      "Get_employee_details": {
        "type": "Compose",
        "inputs": {
          "Name": "@triggerOutputs()?['body/Name']",
          "Email": "@triggerOutputs()?['body/Email']"
        }
      }
    }
  }
}
# Your code here to add the Compose action

Need a hint?

Use a Compose action to extract Name and Email from the trigger outputs using expressions.

3

Add an action to send a welcome email

Add an action using the Office 365 Outlook connector called Send an email (V2). Set the To field to the employee's email from the Compose action, the Subject to Welcome to the Company, and the Body to Hello, [Name]! Welcome to the team. where [Name] is the employee's name from the Compose action.

Azure

{
  "definition": {
    "triggers": {
      "When_an_item_is_created": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connection": {
              "name": "/subscriptions/{subscription-id}/resourceGroups/{resource-group}/providers/Microsoft.Web/connections/sharepoint"
            }
          },
          "method": "get",
          "path": "/datasets/default/tables/NewEmployees/onnewitems",
          "queries": {
            "siteUrl": "https://contoso.sharepoint.com/sites/employees",
            "listName": "NewEmployees"
          }
        },
        "recurrence": {
          "frequency": "Minute",
          "interval": 3
        }
      }
    },
    "actions": {
      "Get_employee_details": {
        "type": "Compose",
        "inputs": {
          "Name": "@triggerOutputs()?['body/Name']",
          "Email": "@triggerOutputs()?['body/Email']"
        }
      },
      "Send_welcome_email": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connection": {
              "name": "/subscriptions/{subscription-id}/resourceGroups/{resource-group}/providers/Microsoft.Web/connections/office365"
            }
          },
          "method": "post",
          "path": "/v2/Mail",
          "body": {
            "To": "@outputs('Get_employee_details')?['Email']",
            "Subject": "Welcome to the Company",
            "Body": "Hello, @outputs('Get_employee_details')?['Name']! Welcome to the team."
          }
        }
      }
    }
  }
}
# Your code here to add the Send email action

Need a hint?

Use the Office 365 Outlook connector's Send an email (V2) action. Use dynamic content from the Compose action for the email fields.

4

Finalize and save the Logic App workflow

Add the $schema property with value https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json# at the root of the Logic App definition. This completes the Logic App JSON structure for deployment.

Azure

{
  "definition": {
    "triggers": {
      "When_an_item_is_created": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connection": {
              "name": "/subscriptions/{subscription-id}/resourceGroups/{resource-group}/providers/Microsoft.Web/connections/sharepoint"
            }
          },
          "method": "get",
          "path": "/datasets/default/tables/NewEmployees/onnewitems",
          "queries": {
            "siteUrl": "https://contoso.sharepoint.com/sites/employees",
            "listName": "NewEmployees"
          }
        },
        "recurrence": {
          "frequency": "Minute",
          "interval": 3
        }
      }
    },
    "actions": {
      "Get_employee_details": {
        "type": "Compose",
        "inputs": {
          "Name": "@triggerOutputs()?['body/Name']",
          "Email": "@triggerOutputs()?['body/Email']"
        }
      },
      "Send_welcome_email": {
        "type": "ApiConnection",
        "inputs": {
          "host": {
            "connection": {
              "name": "/subscriptions/{subscription-id}/resourceGroups/{resource-group}/providers/Microsoft.Web/connections/office365"
            }
          },
          "method": "post",
          "path": "/v2/Mail",
          "body": {
            "To": "@outputs('Get_employee_details')?['Email']",
            "Subject": "Welcome to the Company",
            "Body": "Hello, @outputs('Get_employee_details')?['Name']! Welcome to the team."
          }
        }
      }
    }
  }
}
# Your code here to add the $schema property

Need a hint?

The $schema property is required at the root of the Logic App JSON to define the schema version.