Azure Table Storage

This connector is available in the following products and regions:

Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions and Integration Service Environments (ISEs)
Power Automate	Premium	All Power Automate regions
Power Apps	-	Not available

Contact
Name	Microsoft
URL	Microsoft LogicApps Support Microsoft Power Automate Support

Connector Metadata
Publisher	Microsoft
Website	https://azure.microsoft.com/services/storage/tables/

To use this integration, you will need access to an Azure storage account. More information can be found here. When trying to make a connection, you will be prompted to provide your storage account name and your storage key. The name of your storage account can be found in the URL, for example if your URL is https://myaccount.table.core.windows.net then the account name would be "myaccount". If you have multiple accounts, provide the one you would like to use and select Create. If you see an error during creation, check the account name and the key and try again. You're now ready to start using this integration.

Known issues and limitations

1. Logic apps can't directly access storage accounts that are behind firewalls if they're both in the same region. As a workaround, you can have your logic apps and storage account in different regions. For more information about enabling access from Azure Logic Apps to storage accounts behind firewalls, see the Access storage accounts behind firewalls

Managed identity authentication and Azure Table Storage connector

Currently, managed identity authentication is only supported in Logic Apps. Follow steps below to use it to connect to your Azure Table Storage data:

1. Create an Azure Managed Identity
2. Give identity access to Azure Blob resources. For more details, visit Authorize access to blobs using Microsoft Entra ID.
3. If using a user-assigned identity, associate the logic app with the managed identity
   1. Navigate to the Logic App that will use the managed identity.
   2. Under Settings section of the blade, click Identity
   3. Go to User assigned tab and click on Add
   4. Select the managed identity to be used and click on Add

For more information about authenticating with managed identities in Logic Apps visit Authenticate access to Azure resources using managed identities in Azure Logic Apps

Known limitations with Microsoft Entra ID authentication

Due to current authentication pipeline limitations, Microsoft Entra ID guest users aren't supported for Microsoft Entra ID connections to Azure Table Storage. When using Microsoft Entra ID or Managed identity authentication only V2 actions are supported. Deprecated actions will continue to work with Access Key authentication, but will fail if used with an Microsoft Entra ID or Managed identity connection.

Connect to Azure Table Storage connector using table endpoint

Enter the full Azure Storage table endpoint when creating an "Access Key" connection or using V2 operations.

• For "Access Key" authentications, enter the full Azure Storage table endpoint on Azure Storage account name or table endpoint parameter.

  • When using "V2" operations with "Access Key" authentication, the table endpoint must be provided in the storageAccountName parameter as well.

• For "V2" operations, enter the full Azure Storage table endpoint on storageAccountName parameter.

• You must provide the full endpoint, including the schema, for example:

  • https://account.table.core.windows.net/
  • https://account-secondary.table.core.windows.net/ (if connecting to the secondary endpoint)
  • Relative paths (for example, account.table.core.windows.net) will be rejected.

Get the Azure Storage table endpoint for a given storage account

There are multiple ways to get this table endpoint:

• Using Azure portal

  1. On Microsoft Azure, navigate to the Azure Storage account you wish to connect
  2. Under Settings section (left blade), click on Endpoints
  3. The table endpoint will be under Table service, on the table service text box.

• Using Storage Accounts - Get Properties REST API call

  1. Get the Azure Storage account subscription Id and resource group name.
  2. Navigate to Storage Accounts - Get Properties
  3. Click on the Try it button on the top right corner of the HTTP call
  4. Sign in (the user should have access to the storage account)
  5. Choose the Azure tenant the Azure Storage account is located on
  6. Enter the Azure Storage's account name, resource group name, and select the subscription the storage account is located on.
  7. Click Run
  8. The table endpoint will be on table property under primaryEndpoints object on the response

Creating a connection

The connector supports the following authentication types:

Access Key	Provide Azure Storage account name (or table endpoint) and Access Key to access your Azure Table Storage.	All regions except Azure Government and Department of Defense (DoD) in Azure Government and US Government (GCC) and US Government (GCC-High)	Shareable
Access Key (Azure Government)	Provide Azure Storage account name (or table endpoint) and Access Key to access your Azure Table Storage.	Azure Government and Department of Defense (DoD) in Azure Government and US Government (GCC) and US Government (GCC-High) only	Shareable
Azure AD Integrated	Use Azure Active Directory to access your Azure Table storage.	MOONCAKE only	Not shareable
Azure AD Integrated (Azure Government)	Use Azure Active Directory to access your Azure Table storage.	Azure Government and Department of Defense (DoD) in Azure Government and US Government (GCC) and US Government (GCC-High) only	Not shareable
Logic Apps Managed Identity	Create a connection using a Managed Identity	LOGICAPPS only	Shareable
Microsoft Entra ID Integrated	Use Microsoft Entra ID to access your Azure Table storage.	All regions except Azure Government and Department of Defense (DoD) in Azure Government and MOONCAKE and US Government (GCC) and US Government (GCC-High)	Not shareable
Service principal authentication	Use your Microsoft Entra ID application for service principal authentication.	All regions except Azure Government and Department of Defense (DoD) in Azure Government and MOONCAKE and US Government (GCC) and US Government (GCC-High)	Not shareable
Service principal authentication	Use your Azure Active Directory application for service principal authentication.	Azure Government and Department of Defense (DoD) in Azure Government and MOONCAKE and US Government (GCC) and US Government (GCC-High) only	Not shareable
Default [DEPRECATED]	This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.	All regions	Not shareable

Access Key

Auth ID: keyBasedAuth

Applicable: All regions except Azure Government and Department of Defense (DoD) in Azure Government and US Government (GCC) and US Government (GCC-High)

Provide Azure Storage account name (or table endpoint) and Access Key to access your Azure Table Storage.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name	Type	Description	Required
Azure Storage account name or table endpoint	string	Name or table endpoint of your Azure Storage account	True
Shared Storage Key	securestring	The shared storage key of your Azure Storage account	True

Access Key (Azure Government)

Auth ID: keyBasedAuth

Applicable: Azure Government and Department of Defense (DoD) in Azure Government and US Government (GCC) and US Government (GCC-High) only

Provide Azure Storage account name (or table endpoint) and Access Key to access your Azure Table Storage.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name	Type	Description	Required
Azure Storage account name or table endpoint	string	Name or table endpoint of your Azure Storage account	True
Shared Storage Key	securestring	The shared storage key of your Azure Storage account	True

Azure AD Integrated

Auth ID: tokenBasedAuth

Applicable: MOONCAKE only

Use Azure Active Directory to access your Azure Table storage.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Azure AD Integrated (Azure Government)

Auth ID: tokenBasedAuth

Applicable: Azure Government and Department of Defense (DoD) in Azure Government and US Government (GCC) and US Government (GCC-High) only

Use Azure Active Directory to access your Azure Table storage.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Logic Apps Managed Identity

Auth ID: managedIdentityAuth

Applicable: LOGICAPPS only

Create a connection using a Managed Identity

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name	Type	Description	Required
Managed Identity	managedIdentity	Sign in with a Managed Identity	True

Microsoft Entra ID Integrated

Auth ID: tokenBasedAuth

Applicable: All regions except Azure Government and Department of Defense (DoD) in Azure Government and MOONCAKE and US Government (GCC) and US Government (GCC-High)

Use Microsoft Entra ID to access your Azure Table storage.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Service principal authentication

Auth ID: servicePrincipalAuth

Applicable: All regions except Azure Government and Department of Defense (DoD) in Azure Government and MOONCAKE and US Government (GCC) and US Government (GCC-High)

Use your Microsoft Entra ID application for service principal authentication.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name	Type	Description	Required
Client ID	string		True
Client secret	securestring		True
Tenant ID	string		True

Service principal authentication

Auth ID: servicePrincipalAuth

Applicable: Azure Government and Department of Defense (DoD) in Azure Government and MOONCAKE and US Government (GCC) and US Government (GCC-High) only

Use your Azure Active Directory application for service principal authentication.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name	Type	Description	Required
Client ID	string		True
Client secret	securestring		True
Tenant ID	string		True

Default [DEPRECATED]

Applicable: All regions

This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name	Type	Description	Required
Azure Storage account name or table endpoint	string	Name or table endpoint of your Azure Storage account	True
Shared Storage Key	securestring	The shared storage key of your Azure Storage account	True

Throttling Limits

Name	Calls	Renewal Period
API calls per connection	1200	60 seconds

Actions

Create table (V2)	This operation adds a table to the storage account.
Create table [DEPRECATED]	This action has been deprecated. Please use Create table (V2) instead. This operation adds a table to the storage account.
Delete a table (V2)	Delete a table.
Delete a table [DEPRECATED]	This action has been deprecated. Please use Delete a table (V2) instead. Delete a table.
Delete Entity (V2)	Operation to delete an entity.
Delete Entity [DEPRECATED]	This action has been deprecated. Please use Delete Entity (V2) instead. Operation to delete an entity.
Get a table (V2)	This operation gets the metadata of a table.
Get a table [DEPRECATED]	This action has been deprecated. Please use Get a table (V2) instead. This operation gets the metadata of a table.
Get entities (V2)	This operation queries the entities in a table.
Get entities [DEPRECATED]	This action has been deprecated. Please use Get entities (V2) instead. This operation queries the entities in a table.
Get entity (V2)	This operation gets the entity in a table based on the partition and row key.
Get entity [DEPRECATED]	This action has been deprecated. Please use Get entity (V2) instead. This operation gets the entity in a table based on the partition and row key.
Insert Entity (V2)	Operation to add an entity to a table.
Insert Entity [DEPRECATED]	This action has been deprecated. Please use Insert Entity (V2) instead. Operation to add an entity to a table.
Insert or Merge Entity (V2)	Operation to merge data with an entity in a table, creating a new entity if needed.
Insert or Merge Entity [DEPRECATED]	This action has been deprecated. Please use Insert or Merge Entity (V2) instead. Operation to merge data with an entity in a table, creating a new entity if needed.
Insert or Replace Entity (V2)	Operation to replace an entity in a table, creating a new entity if needed.
Insert or Replace Entity [DEPRECATED]	This action has been deprecated. Please use Insert or Replace Entity (V2) instead. Operation to replace an entity in a table, creating a new entity if needed.
List tables (V2)	List all the tables for your storage account.
List tables [DEPRECATED]	This action has been deprecated. Please use List tables (V2) instead. This operation lists the tables in the account.
Merge Entity (V2)	Operation to merge data with an entity in a table.
Merge Entity [DEPRECATED]	This action has been deprecated. Please use Merge Entity (V2) instead. Operation to merge data with an entity in a table.
Replace Entity (V2)	Operation to replace an entity in a table.
Replace Entity [DEPRECATED]	This action has been deprecated. Please use Replace Entity (V2) instead. Operation to replace an entity in a table.

Create table (V2)

Create table [DEPRECATED]

Delete a table (V2)

Delete a table [DEPRECATED]

Delete Entity (V2)

Delete Entity [DEPRECATED]

Get a table (V2)

Get a table [DEPRECATED]

Get entities (V2)

Get entities [DEPRECATED]

Get entity (V2)

Get entity [DEPRECATED]

Insert Entity (V2)

Insert Entity [DEPRECATED]

Insert or Merge Entity (V2)

Insert or Merge Entity [DEPRECATED]

Insert or Replace Entity (V2)

Insert or Replace Entity [DEPRECATED]

List tables (V2)

List tables [DEPRECATED]

Merge Entity (V2)

Merge Entity [DEPRECATED]

Replace Entity (V2)

Replace Entity [DEPRECATED]

Definitions

getTablesResponse

getTableResponse

Item

getEntitiesResponse

getEntityResponse

InsertEntityResponse