Common Data Service Business Flows

[MartinHutch]

Having read https://www.nigelfrank.com/microsoft-dynamics-blog/microsoft-dynamics-365-the-common-data-model-expl... we are keen to use Business Process Flows between some of our external systems and Dynamics 365 Version 9.

I want to create Business Process Flows in the default environment in model driven mode.

However, we cant  because a database has not been created.

I have tried the following:-

1. In the default environment, Business Logic/Flows section the error is "You don't have a database. Create a database to start building flows using entities from the Common Data Service for Apps." 

2. In the Entities section of Data, we are told to create a database, but when I try I get the error "It looks like you don't have permission to use the Common Data Service in this environment. Switch to a different environment, or create your own."

I cant see our Dynamics 365 Entities here. They should be listed in the same way a fresh and basic entity list appears when I create a new environment alongside our default one in the Admin Centre. I am the global admin.

3. If I try to create the database in the PowerApps Admin centre I get the error "The default environment’s region ('europe') is different from your company’s Azure Active Directory home location ('unitedkingdom'). Creating a database here isn’t available."

I have had a number of conversations with Microsoft support and they have told me that this is not a bug, but a limitation of the system and actually not related to the location of the region or AAD at all.

I cant believe I should not be able to see our default Dynamics 365 entities and work with these. I thought this was the main purpose of the new powerapps CDS.

Here is the quote.

 "My name is Srinivas Neelapalayam and I am the Operations Manager here at Microsoft. We have done extensive research and troubleshooting to understand the issue which you are facing. However we will convey your feedback to Product team in order to add this feature to MS Flow.

Our Product team pushes improvements and features on weekly basis. These improvements are planned well in advance. But there are some of the improvements which will have lot of dependencies due to which it takes long time and sometimes it becomes extremely hard for us to define an ETA even though we have a road map of improving the feature. We hope you understand the complexity here. Our focus is always on improving customer experience and giving what customer is looking for sooner or later.

We would encourage you to see if this idea already exists. If not please post this awesome idea @<<MS Flow Ideas>> and vote for it. 

At this moment we cannot do much from our side. So We look forward to hearing back from you and receiving confirmation that we can achieve this ticket."

Anybody shed any light?

Thanks

[CWesener]

Hi @MartinHutch - can you confirm if you can see your environment in the drop down in the top right hand corner? It should be in the format Your Environment name (URL prefix) - the URL prefix should match your prefix from yourprefix.crm.dynamics.com. 

If you do see your envioronment, please try selecting it and see if the same problem exists. If you don't see your environment, please send me a private message with your CRM environment URL - and I'll make sure you have a linked environment.

Thanks,

Clay.

[MartinHutch]

Hi Clay,

Sorry I was out of the office yesterday.

Yes I can see our Dynamics CRM as the Default Environment in the drop down box. It is shown as Cambridge Professional Academy(default).

When I select this and then look at "Entities" I am told to "Create database", which does not work because "It looks like you don't have permission to use the Common Data Service in this environment. Switch to a different environment, or create your own."

Martin

[CWesener · Accepted solution]

Hi Martin,

Your CRM environment wont be your default, it will\should be showing as a seperate environment  - It will have your name and then in brackets it should match the prefix to your CRM environment, so for example if your envinronment was contosousa.crm.dynamics.com, it would show as Contoso Industries (contosousa)  in the environment drop down. If you dont see this, there are two possible causes - you don't have System Customizer permissions to your environment, or there has been a problem on our side and its not showing in the PowerApps portal.

If you can confirm you have permissions to access your envionrment, I can check and make sure your enviornment is available for PowerApps - if you can send me a private message with your environment URL (contosousa.crm.dynamics.com) I can get our team to check.

Thanks,

Clay.

[MartinHutchcpa]

Hi Clay,

I am pleased to say the bug has now been fixed.

-----------------------------

Hello Martin,

There was a known issue with the CRM instance due to which the installation of the CDSManagement package was blocked.

The issue is fixed and is deployed yesterday, hence unblocking you.

Best Regards,

Khushbu Kumari

-------------------------------------------------------

Regards,

Martin

[CWesener]

Great to hear, Martin!

[FemaleMarvel365]

Hi! We are having the same issue with this. We are attempting to use the edit environment role connector with a service principle that has Directory Read Write all, group read write all, and user read write all shared connection. What was done to fix this?