Flow Approval CDS Provisioning Errors and Recommendations

Applies to: Power Automate

Common Error Cases and Resolutions


Failed to create the Common Data Service database in this environment with status code 'ViralServicePlanRequired' 

This error occurs in organizations that have disabled self-service signups. Self-service signups are required to assign viral plans to users attempting to provision resources and interact with the Common Data service. Tenants have multiple options to resolve this: 

  1. Enable AllowAdHocSubscriptions (tenant level configuration) via PowerShell 

Install the MSOnline module if necessary: 

Install-Module MSOnline 

Connect to your organization: 

Connect-MsolService 

Confirm that AllowAdHocSubscriptions is false. 

Get-MsolCompanyInformation | fl AllowAdHocSubscriptions 

Enable AllowAdHocSubscriptions 

Set-MsolCompanySettings -AllowAdHocSubscriptions $true 

 

  1. Assign a paid Microsoft Flow plan (P1 or P2) to the users attempting to first provision approvals or a Common Data Service database via https://portal.office.com. This is only necessary to get the database provisioned.  

Note: Trial plans are not sufficient to for Approval CDS provisioning. GCC tenants can only use approach #2 to be able to provision database instances. 

  1. Create the database as an environment admin directly from https://admin.flow.microsoft.com 

 

Failed to create the Common Data Service database in this environment with status code 'AADApplicationDisabled'. 

Resource 'https://publishers.crm.dynamics.com' has been disabled by your tenant administrator. Contact your tenant administrator and request that they enable 'https://publishers.crm.dynamics.com' in the Azure Portal.'. 

These errors occur if the Dynamics CRM Online / Common Data Service applications are disabled either in the tenant, or through Conditional Access for specific users. The exact error message may vary depending on the exact state of the Common Data Service instance corresponding to the PowerApps/Flow environment – un-provisioned, provisioned but no Approvals installed, or Approvals already installed. 

To resolve, tenant administrators will need to go to the Enterprise Applications tab under “Azure Active Directory” on https://portal.azure.com to ensure application 00000007-0000-0000-c000-000000000000 (Common Data Service / Dynamics CRM Online) is enabled for users to sign in, and any relevant Conditional Access policies grant the necessary access to users expecting to use Flow Approvals. 

Enable Dynamics CRM Online in the Azure Portal

The Common Data Service database for this environment is disabled 

The Common Data Service instance has been disabled in this environment. This is not expected, and is may related to the expiration of all Flow & CDS plans within your AAD tenancy. To ensure the database can be enabled, make sure at least one user has active plans. 

The Common Data Service Database for this environment is not ready yet. 

The database for this instance is still being provisioned, or has failed provisioning. Re-running a Flow that uses approvals will attempt to re-provision the instance.  

The current user does not have permissions to create a Common Data Service database for this environment.  

For non-Default Flow and PowerApps environments, only environment admins can directly (through the Flow Admin portal) or indirectly (through Flow Approvals) create the Common Data Service database. Either an administrator must 

  • Create the environment manually from the Flow Admin portal 

  • Create and run an Approvals Flow 

  • Grant environment administrator permission to the current user.