Insert or update row
Performs an insert or update on a table based on column-value mappings and returns the name of the action performed.
Example 
The Flow above illustrates how to use the Insert or Update row action to save customer information to a SQL Server database fetched from a web API. Actions used in this Flow are: HTTP Request, Insert or update row, and Send email.
Properties
| Name | Type | Description |
|---|---|---|
| Title | Optional | A descriptive title for the action. |
| Connection | Required | The SQL Server connection. |
| Dynamic connection | Optional | Use this option of you needs to use a connection from the Create Connection action. |
| Table name | Required | The name of the table to insert or update a row. |
| Column value mapping | Required | Defines the row to update by specifying the columns and corresponding values. |
| Result variable name | Optional | Name of the variable containing the action performed. This always returns either INSERT or UPDATE. |
| Command timeout (sec) | Optional | The time limit for command execution before it times out. Default is 120 seconds. |
| Description | Optional | Additional notes or comments about the action. |
Videos / Getting started
This section contains videos to help you get started quickly working with Azure SQL / SQL Server using Flow.
Dump CSV file from Azure Blob container to Azure SQL table
This video demonstrates how to import all records from a CSV file into an Azure SQL table.
In the demo, no data import options (such as data type conversion, number or date formatting) are specified, meaning the data is imported as raw text.