You're reading from Workflow Automation with Microsoft Power Automate Drive digital transformation with AI-powered automation and low-code business workflows

Product type Paperback

Published in Dec 2025

Publisher Packt

ISBN-13 9781836649632

Length 605 pages

Edition 3rd Edition

Tools

Power Platform

Concepts

Business Process Management

Author (1):

Aaron Guilmette

View More author details

Table of Contents (28) Chapters

1. Workflow Automation with Microsoft Power Automate: Drive digital transformation with AI-powered automation and low-code business workflows FREE CHAPTER

2. Chapter 1: Introducing Microsoft Power Automate

3. Chapter 2: Getting Started with Power Automate

4. Chapter 3: Working with email

5. Chapter 4: Copying files

6. Chapter 5: Creating Button Flows

7. Chapter 6: Generating push notifications

8. Chapter 7: Working with shared flows

9. Chapter 8: Working with Conditions

10. Chapter 9: Understanding Expressions and Functions

11. Chapter 10: Getting Started with Approvals

12. Chapter 11: Working with Multiple Approvals

13. Chapter 12: Posting Approvals to Teams

14. Chapter 13: Using Databases

15. Chapter 14: Working with Microsoft Forms

16. Chapter 15: Posting to Slack

17. Chapter 16: Accepting User Input

18. Chapter 17: Automating Entra ID

19. Chapter 18: Introducing Robotic Process Automation

20. Chapter 19: Contributing to an Access database with RPA

21. Chapter 20: Automating webpages with RPA

22. Chapter 21: Introducing AI Models and Generative AI

23. Chapter 22: Creating a sentiment analysis flow

24. Chapter 23: Using Copilot to create and manage flows

25. Chapter 24: Using Generative AI to summarize documents

26. Chapter 25: Exporting, importing, and distributing flows

27. Chapter 26: Monitoring and troubleshooting flows

28. Chapter 27: Governance in the Power Platform

Connecting to a database

In this section, we'll look at creating a simple button flow that adds a row of data to a database table. To do this, you'll need a database and a table. In the following example, we'll create a SQL instance and a database that we'll use for our Power Automate configuration.

Creating a server

While you can use any supported database technology with Power Automate, we're going to focus on SQL Server. If you already have an existing SQL server available, you can skip this step. Otherwise, you can provision the necessary components in Azure to start working immediately.

If you do not have access to server infrastructure, you can sign up for a free Azure trial at https://azure.microsoft.com/en-us/offers/ms-azr-0044p/ or by navigating to https://portal.azure.com, signing in with your global admin credential for your trial Microsoft 365 tenant, and then completing the Azure trial sign...