Now that you have configured a server, a database, and a table with columns, you get to see all the pieces working together. In this section, you'll create a flow, execute it, and then verify that it wrote the data successfully.
First, let's create a flow so that we can add content.
Creating the flow
To verify that you've configured database connectivity, we'll walk through creating a sample button or instant flow so that we can post data to the database. Follow these steps to create the flow:
- From the Power Automate web portal (https://flow.microsoft.com), select + Create.
- Under the Start from blank section, select Instant flow.
- Enter a name for the flow, and then select Manually trigger a flow as the trigger type.
- Click Create.
- Click + New step.
- In the search box, enter SQL insert and then select the Insert row (V2) action:
- From the dropdowns for the action, select the server name, database name, and the table name you created...