Power Automate can connect to a number of databases, such as Microsoft SQL Server, Azure SQL Datawarehouse, Postgres SQL, MySQL, DB2, Oracle, and Xoaa Blockchain (as well as the CDS, which we discussed back in Chapter 9, Getting Started with Approvals). Each of these database technologies shares similar mechanics and concepts. In the examples provided in this book, we're going to focus on using Microsoft SQL Server databases and the related connector, but you may want or need to use others, depending on what you have available.
As with other connectors, the SQL connector has both triggers and actions. We'll examine these next.
Triggers
The Microsoft SQL Server connector supports two triggers (at the time of writing):
- When an item is created (v2)
- When an item is modified (v2)
When working with both of these connectors, you'll need to supply a server name, database name, and table name, as well as optional select...