Logic App Archives - Terence Luk

Creating a Logic App that retrieves AAD sign-in events from Log Analytics and sends a report in an email with a CSV attachment and HTML table insert

July 4, 2023

Two of the common questions I’ve been asked since publishing the following post over a year ago: Monitoring, Alerting, Reporting Azure AD logins and login failures with Log Analytics and Logic Apps https://blog.terenceluk.com/2022/02/monitoring-alerting-reporting-azure-ad.html … is whether there was a way to: Provide the report as

Configuring reminders for “Send approval email” action in Logic Apps

April 29, 2023

A few of my contacts reached out to me with questions after my previous post: Using Microsoft Forms and Logic App to create an automated submissions and approval process for Azure AD User Creation https://blog.terenceluk.com/2023/04/using-microsoft-forms-and-logic-app-to.html … where I demonstrated a workflow for using Microsoft Forms

Using Microsoft Forms and Logic App to create an automated submissions and approval process for Azure AD User Creation

April 3, 2023

Being an architect usually means that I do not usually take part in ongoing operational activities when an environment has gone live and therefore the days where I handle requests for new Azure AD account creations are supposed to be behind me but most of

Updated: Create an automated report for Office 365 / Microsoft 365 license usage with friendly names using Azure a Function App (using a system assigned managed identity) and Logic Apps

December 26, 2022

One of my colleagues who used my previous blog post: Create an automated report for Office 365 / Microsoft 365 license usage with friendly names using Azure a Function App and Logic Apps https://blog.terenceluk.com/2022/07/create-automated-report-for-office-365.html … recently informed me that his Function App would fail to

Configuring an Azure Function App that uses a system managed identity to execute Az.Compute module cmdlets that will retrieve all Azure VMs with their Status then use a Logic App run the app and email the report

November 17, 2022

In this post, I would like to demonstrate the following using an Azure Function App and Logic App. Function App: Use the Az.Compute module to execute Get-AzVM to get the list of virtual machines and store it in an array Loop through the virtual machines

Securing Azure Function App to require authentication and granting access to a Logic Apps’ Managed Identity

September 12, 2022

One of the topics I’ve been meaning to write about is how to secure Function Apps with authentication to prevent unauthorized calls because a newly created Function App and its functions are by default accessible via the internet so anyone who knows the URL would

Using Azure Function App and Logic Apps to create an automated report that downloads a CSV, creates a HTML table, sends an email with the HTML table and attaches the CSV

August 25, 2022

In this post, I would like to demonstrate the following using an Azure Function App and Logic App. Function App: Download a CSV file from a URL Count the amount of records in the table Convert the CSV data into a table in HTML format

Create an automated report for Office 365 / Microsoft 365 license usage with friendly names using Azure a Function App and Logic Apps

July 25, 2022

I received quite a few requests about how to automate the process of my previous post where I described how to use Microsoft Graph PowerShell SDK to generate a Office 365 / Microsoft 365 license report that had friendly names: Using Microsoft Graph PowerShell SDK

Microsoft Teams configuration automation using MS Teams Channel, Forms, Logic App and Automation Account with Runbook

June 6, 2022

One of the past projects I worked on for a client was to help them move from a Mitel PBX phone system to Microsoft Teams as their phone system. Aside from the design and implementation for the routing during the transition and cutover, a key

Using a Logic App to send a recurring report for App Registration Certificates & secrets expiry

March 30, 2022

As a follow up to my previous post: Using PowerShell to send custom log data to Log Analytics for Azure Monitor alerting and Kusto Query https://blog.terenceluk.com/2022/03/using-powershell-to-send-custom-log.html I recently looked into how the Certificates & secrets configured for Azure AD App Registrations could be monitored so

Blog

Creating a Logic App that retrieves AAD sign-in events from Log Analytics and sends a report in an email with a CSV attachment and HTML table insert

Configuring reminders for “Send approval email” action in Logic Apps

Using Microsoft Forms and Logic App to create an automated submissions and approval process for Azure AD User Creation

Updated: Create an automated report for Office 365 / Microsoft 365 license usage with friendly names using Azure a Function App (using a system assigned managed identity) and Logic Apps

Configuring an Azure Function App that uses a system managed identity to execute Az.Compute module cmdlets that will retrieve all Azure VMs with their Status then use a Logic App run the app and email the report

Securing Azure Function App to require authentication and granting access to a Logic Apps’ Managed Identity

Using Azure Function App and Logic Apps to create an automated report that downloads a CSV, creates a HTML table, sends an email with the HTML table and attaches the CSV

Create an automated report for Office 365 / Microsoft 365 license usage with friendly names using Azure a Function App and Logic Apps

Microsoft Teams configuration automation using MS Teams Channel, Forms, Logic App and Automation Account with Runbook

Using a Logic App to send a recurring report for App Registration Certificates & secrets expiry

Hello! My name is Terence Luk and welcome to my blog.

Follow me:

Categories

Subscribe to the mailing list to receive posts updates!

Categories

Recent Posts

Setting up a Python Function App with VSCode to configure Blob Metadata stored in an Azure Storage Account

Setting Azure Storage Account Blob Metadata with Python Script