Automate Data Reporting with Azure Functions and Power Automate

Level: Intermediate

Introduction

In this tutorial you'll learn how to migrate a local Node.js script to Azure Functions using Visual Studio Code so that data can be retrieved more easily for reporting purposes. To automate calling the API, you'll learn how to setup a Power Automate flow, call the Azure Function, and store the data in Excel Online.

Here's an overview of the application solution. Power Automate is used to setup a recurring action that calls out to Azure Functions, retrieves JSON data, parses it, extracts the desired values, and stores the data in Excel Online (note that many other storage options could be chosen).

Pre-requisites

• Node - Node LTS
• git
• Visual Studio Code
• Azure Functions Extension for VS Code
• Azure subscription
• Microsoft 365 developer tenant

Technologies used in this tutorial include

• Node.js
• Azure Functions
• GitHub
• Power Automate
• VS Code