Showing results for 
Search instead for 
Did you mean: 
Resolver III
Resolver III

Managed solution with Connection References and Service Principal connections

Hi All,

I'm finding the scenario below harder than I think it should be and I'm wondering if I'm missing something.  Please weigh-in with any insights.

Assume two environments in the same tenant: DEV (unmanaged solution environment) and TEST (managed):

  • Create and configure a new Application User for use in both environments - call it "SPN Flow Execution"
  • In DEV, create a new unmanaged solution - call it "Demo Solution"
    • Add a Flow to the solution - call it "Demo Flow"
      • Trigger:
        • "When a record is selected"
        • Create a new SPN-based connection to Common Data Service - call it "DEV SPN CDS Connection"
        • Account entity or whatever you like
      • Action:
        • "Create a new record"
        • Create a new SPN-based connection to Common Data Service (current environment) - call it "DEV SPN CDS (current) Connection"
        • Create a new Account and add static values for required fields
    • Add a Connection Reference (preview) to the solution - call it "Demo CDS Connection"
      • Connector: Common Data Service
      • Connection: DEV SPN CDS Connection
    • Add another Connection Reference (preview) to the solution - call it "Demo CDS (current) Connection"
      • Connector: Common Data Service (current environment)
      • Connection: DEV SPN CDS (current) Connection
    • Update Flow Trigger and Action to use appropriate Connection References
    • Publish and export solution as managed

In TEST, import solution and see where things start to break down...

When deploying to TEST:

The import process wants the user to associate the Connection References included in the solution with local connections.  At this point, I would expect to be able to create a new connection using the SPN I setup in the environment, however, only user-based connections are displayed and only user-based connections can be created using the "+ New connection" button.

In a given environment, an admin is unable to create an SPN-based connection outside the context of a Flow.  Prior to attempting a solution import I can't go into TEST, navigate to Data -> Connections -> "+ New connection" and create SPN-based connections that will then be associated with the Connection References.

Furthermore, I can't create a quick Flow in test to establish the two new environment-specific connections (e.g. "TEST SPN CDS Connection" and "TEST SPN CDS (current) Connection") and then go back to the solution import UI to refresh the list and choose one.  Hitting refresh and they never show up.



Anyone from the engineering team that can shed some light on the expected deployment scenario here?

Resolver III
Resolver III

Small update...  Instead of using my existing TEST environment I created a fresh TRIAL environment and basically followed the same steps above.

Some observations:

  • Prior to attempting to importing the solution, I created a new local flow (didn't have to save it) with two SPN-based connections: "TRIAL SPN CDS Connection" and "TRIAL SPN CDS (current) Connection".
  • I then imported the solution and was prompted by the UI to associate the Connection References with a local connection and the new local connections appeared in the list.
  • The flows did not activate upon import which I don't fully understand since they were associated with the valid connections.  I had to open them and click "Continue", Save and then Activate.



I assume that the TEST environment I had been using was in a state that the new connection reference/import process does not like... hopefully things get ironed out soon.  It will be nice to have this process work without having to troubleshoot issues.

Also, existing ALM deployments from Azure DevOps are not in a good place due to connection references, but this has been well-documented in the forums.

Helpful resources

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (38,277)