Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Workflow Automation with Microsoft Power Automate

You're reading from   Workflow Automation with Microsoft Power Automate Achieve digital transformation through business automation with minimal coding

Arrow left icon
Product type Paperback
Published in Sep 2020
Publisher Packt
ISBN-13 9781839213793
Length 302 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Aaron Guilmette Aaron Guilmette
Author Profile Icon Aaron Guilmette
Aaron Guilmette
Arrow right icon
View More author details
Toc

Table of Contents (22) Chapters Close

Preface 1. Section 1 - What is Power Automate?
2. Introducing Power Automate FREE CHAPTER 3. Section 2 - Basic Flow Concepts
4. Getting Started with Power Automate 5. Working with Email 6. Copying Files 7. Creating Button Flows 8. Generating Push Notifications 9. Working with Team Flows 10. Section 3 - Intermediate Flow Concepts
11. Working with Conditions 12. Getting Started with Approvals 13. Working with Multiple Approvals 14. Posting Approvals to Teams 15. Using a Database 16. Working with Microsoft Forms 17. Accepting User Input 18. Section 4 - Administering the Power Automate Environment
19. Exporting, Importing, and Distributing Flows 20. Monitoring and Troubleshooting Flows 21. Other Books You May Enjoy

Adding database content

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.

To create a SQL server in Azure, follow these steps:

  1. Navigate to https://portal.azure.com and sign into a tenant using an account with administrative privileges. (If you don't currently have an Azure subscription, you can sign up for a trial).
  2. From the search bar, begin typing SQL and select SQL Servers.
  3. Click +Add.
  4. Select a subscription and a resource group. If you do...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime