Azure Table Storage Connection
When adding an Azure Table Storage action, select an existing connection or create a new one.
Flow supports multiple connection methods:
- SAS URI to a storage account with access to all tables
- SAS URI to a specific Azure Table
- Connection string to the storage account
- Connection string + Table name
Connection properties
Name | Description |
---|---|
Connection Name | A custom label for the connection. This name will appear when selecting a connection in a Flow action. |
Connection Type | Choose how to connect to Azure Table Storage. Options: • SAS URI (Account or Table) • Connection String • Connection String + Table Name |
SAS URI
This method uses a Shared Access Signature (SAS) URI to grant access to your Azure Table or account. It is the most secure and scoped method.
Name | Description |
---|---|
SAS URI | A URI that includes the SAS token, permissions, and expiration. This can either target the entire storage account or a specific table. |
Note
If your SAS URI points to the storage account, it must include permission to access table services (ss=t
). Ensure it also includes Table-level permissions, such as sp=raud
(Read, Add, Update, Delete).
Generate a SAS URI
- Open the Azure Portal.
- Go to Storage accounts and select your account.
- In the left menu, select Shared access signature under Settings.
- Check the box for Table under Allowed services.
- Choose desired permissions (Read, Add, Update, Delete).
- Set start and expiry time.
- Click Generate SAS and connection string.
- Copy the Table service SAS URL.
Example (SAS URI to account):
https://mystorageaccount.table.core.windows.net/?sv=2022-11-02&ss=t&srt=sco&sp=raud&se=2025-08-01T00:00:00Z&st=2025-07-21T00:00:00Z&spr=https&sig=xyz...
Example (SAS URI to table):
https://mystorageaccount.table.core.windows.net/mytable?sv=2022-11-02&ss=t&srt=sco&sp=raud&se=2025-08-01T00:00:00Z&st=2025-07-21T00:00:00Z&spr=https&sig=xyz...
Connection String (with or without table name)
This method uses a full connection string for the Azure Storage account. You can optionally include the table name.
Name | Description |
---|---|
Connection String | The full connection string from Azure Storage. Grants access to all tables under that account. |
Table Name (optional) | Specify if you want the connection to always target a specific table. |
Get the Connection String
- In the Azure Portal, navigate to Storage accounts.
- Choose your account.
- In the left-hand menu, select Access keys under Security + networking.
- Copy either Connection string (key1 or key2).
Example:
DefaultEndpointsProtocol=https;AccountName=mystorageaccount;AccountKey=abcd1234...;EndpointSuffix=core.windows.net
Tip
For improved security, you can use a connection string with a SAS token instead of an account key.
Summary of Supported Connection Types
Type | Description |
---|---|
SAS URI (Account) | Full URI to storage account, with table permissions |
SAS URI (Table) | URI scoped to a specific Azure Table |
Connection String | Access to entire account (all tables) |
Connection String + Table Name | Limits actions to the specified table |