Table of Contents

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

img


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

  1. Open the Azure Portal.
  2. Go to Storage accounts and select your account.
  3. In the left menu, select Shared access signature under Settings.
  4. Check the box for Table under Allowed services.
  5. Choose desired permissions (Read, Add, Update, Delete).
  6. Set start and expiry time.
  7. Click Generate SAS and connection string.
  8. 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...

Azure Table - SAS URI


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

  1. In the Azure Portal, navigate to Storage accounts.
  2. Choose your account.
  3. In the left-hand menu, select Access keys under Security + networking.
  4. Copy either Connection string (key1 or key2).

Example:

DefaultEndpointsProtocol=https;AccountName=mystorageaccount;AccountKey=abcd1234...;EndpointSuffix=core.windows.net

Azure Table - Connection String

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