connection not configured for this service

[aaroh_bits]

Hi All,

Background Info

• Using Power Apps and Power Automate with back end as Dataverse.
• All Artefacts are under a Solution with maker.powerapps.com for ease to move to environments at later stage.   
• We need to generate PDF via OneDrive (no premium connector)  and send email to end user when workflow completes.
  
  

What Works:

• As flow owners for that workflow and has following connections
  
  
  
  
• Once workflow kicks in a success message in Power Apps is shown as
• Submit button action in Power Apps is as follows:

If(
   Not(IsSubmitError),
    IfError(
        PurchaseRequestApprovalSubmission.Run(Text(HelpDeskWorkflow)),
        UpdateContext({IsSubmitError: true});
        Notify(
            "The workflow was failed to start. Message: " & ErrorInfo.Message & "& Error Kind" & ErrorKind,
            Error
        ),
        UpdateContext({IsSubmitError: false})
    )
);

What does not work

Other non- flow owners do not trigger the workflow

• 
  User Alex as following connection and OneDrive connected for Alex’s account.
  
• But when I clicks on Submit  workflow, he gets this error
  
  
• Tried may other options such as
• We removed the OneDrive action inside flow, then re-add back. Then updating the connection reference inside the app.
• We ensured there’s no other dummy connection inside the flow. Then updating the connection reference inside the app.
• We Deleted the OneDrive connection that connects to the flow, then re-add back. Then updating the connection reference inside the app.
• We created another dummy app, trigger the workflow, then the error message shows up as: “HelpDeskWorkflow.Run failed: connection not configured for this service”.
• We created another dummy app, create another dummy flow, both are outside the solution, the workflow triggers just fine.
• We Exported the flow package (.zip), then import back to the environment.
• With the imported flow package (.zip), we created another dummy app and trigger the workflow, it works as per normal again. The flow was imported outside the solution and can’t be added into the solution.

Stumbled into a quite a few of issues in the community forum

PowerApps Flow Error : "Connection not configured for this service", when its in included in the Managed Solution and deployed

https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApps-Flow-Error-quot-Connection-not-con...
My experience with connector/connection problems, and multiple connections to same connector  
https://powerusers.microsoft.com/t5/Connecting-To-Data/My-experience-with-connector-connection-probl...

Connection not configured for this service (with Microsoft Support ticket details )

https://powerusers.microsoft.com/t5/Building-Power-Apps/Connection-not-configured-for-this-service/m...

Any suggestions or pointer will be greatly appreciated.

@martinav @CFernandes  @jinivthakkar  @Pstork1  @v-xida-msft 

[Gilmour]

Thank you for this post!!!

[Aedu]

Hello together
We have followed all the points, but it still does not work for us:
- All users are users with security role Basic User
- Security role adjusted for process on Read Organization
- Run Only Users for the flows are set. All users are allowed to run the flows
- Solutions are imported with the same account that is used for development. This means that the owner of all artifacts (app, flow, connection references, connection) is the same in all environments.

Our deployment policy is that we can only install managed.

Currently our solution after installing or updating a solution is to open the app in the managed environment in edit mode, remove all flows and re-add them.

Any other ideas on what else can be done to fix the problem?

[Vitss]

My experience is you may not edit the apps in the Edit Mode. It breaks your solution. After doing that the App updates dit not came through (although the version number was updated).

My advice is

• to import solutions with a service account (that also need to have all licenses needed to make the apps and flows) that ensures the working of all solutions, custom connectors etc. after the builder may have left the company.
• Make sure on which connector the service is failing.
• In case of Custom connectors, what caused a problem with me, you need an extra solution with this connectors in it, it seamed crucial to enroll this solution before the solution using the connectors.
• If using an onPrem datagateway make sure the users that trigger the flow using a connector using the gateway needs to have admin rights on the gateway.

[Aedu]

Thank you for your reply.

Maybe I was not precise enough. Development of all artifacts and deployment is already done with a service account.
The app uses 8 flows. In the dev environment everything works fine (of course). After the managed installation or update in the test environment (where we remove all unmananged layers beforehand) no more flows can be called from the app. It is like the link between the app and the flows is broken (as described in the original problem message at the beginning of this thread). It is not that the connections of the flows are no longer authorized. And we already have a custom solution for the custom connectors, which we import first, then make sure they are reauthorized before importing the solution with the app and flows. OnPrem Data Gateway is not in the game.

[Vitss]

And in the test environment?

If it does not work there either I suggest deleting the whole solution(s) and reimport it again.

[Aedu]

That might just work. But since this is a customer installation where > 30 people are testing, this would not be such a good idea because it changes the link to the app.
And most importantly, it wouldn't work in the Productive environment because then > 300 users would have to get a new link every time after each update.

[Vitss]

For the test environment, my opinion is that is where it is mentioned for, the Prod environment that is indeed critical. 

Log a service request with microsoft itself?

[sky_sats]

Yes I have the same issue too.

When i deploy from Dev to Test, Dev is unmanaged and Test is Managed solution.

One of the flow status is Not Connected after deployed to Test environment. 

I need to click connected manually after I deployed to Test. It created an unmanaged layer which is very annoying. 

[MatthewBurrows]

This can cause potential issues if you were to want to get your app pen tested as users are able to query the process table via the api and return the definition of all flows even ones they shouldn't see.

We have been able to resolve this by using the "Power App (V2)" trigger. This then allows you to set run-only permissions for the flow. Here are the exact steps we use.

1. Create a team in dataverse ( we used and Azure AD Security group) and ensure all users that need to run your flow are added to it.
2. Create a Flow that uses the "Manually triger a flow" trigger. This flow contains all the logic and connections to dataverse using the connection reference. This flow ends with a "Response" action to pass the result back to the parent flow.
3. On this flow go to the details screen and click Edit on the "Run only users" section. Under "connections used change all options from "Provide by run only user" to "Use this connection....".
4. Create a flow that uses the "Power Apps (V2)" trigger. This flow then uses the "Run a child flow" action to call the flow created in step 2. This flow ends with a "Response" action to pass the result back to the app.
5. On this flow go to the details screen and click Edit on the "Run only users" then add the group created at step1 to the list of run only users.

Hope this is helpful as I have been unable to find an example explaining this.

Update 

A small change you don't need to have 2 separate flows as long as on the one with the connections you do step 3.

[Gilmour]

Thank you @MatthewBurrows will give it a try!

[leeal]

Hi there, we've encountered a similar issue with one of our customers ("Connection not configured for this service"). They are hesitant to either add users to a security group or alter security roles for other users. Is there any other workaround we can try/recommend to them?

[marcosrobles]

Hi I have the same issue.

I have even deleted slq connections in my development environment, My app and flows just make http requests to an api.

It does not use sql connections directly.

I tried with the solution provided and I got the same error.

[MatthewBurrows]

@leeal Do you only get this problem once you package up the solution and deploy to a new environment? Or are you getting it in the environment where you developed the app?

[MatthewBurrows]

@marcosrobles are you able to post a screenshot of the flows section in details for the app and the details screen of the flow?