Creating a connection to a database

As you learned earlier in the chapter, when working with databases, you'll need to tell an application how to connect to a database. That data is stored in a configuration object generally called a connection string. In Power Automate, the connection string data is referred to as a connection.Connection details will depend on the type of database you're connecting to, but the most common fields or properties that you'll need to populate include a server name or IP address, credentials, port numbers, and a database name.To connect to a database in Power Automate, follow these steps:

1. Navigate to the Power Automate maker web portal (https://make.powerautomate.com). Expand More and click Connections.

2. Select New connection.

   

   Figure 13.10 - Creating a new connection

3. Select SQL Server from the list of connection types:

   

   Figure...