web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : yTFg5+FgeyWOxpxbuvrXGJ
Power Apps - Building Power Apps
Unanswered

Deployed PowerApp is Prompts for User Connection Authentication

Like (0) ShareShare
ReportReport
Posted on 6 Mar 2024 20:09:31 by 1,278 Moderator

My PowerApp has a Flow attached to it. I am using a service account for the connections to send an Email and access a SharePoint Site. I expected the app to maintain this when I published it to another Environment, but it's prompting the user at startup.

20240306_195614934_iOS.png

 

How do I avoid this? The user shouldn't be prompted to use their account for connections I purposefully setup to use a service account.

  • Pstork1 Profile Picture
    67,165 Most Valuable Professional on 08 Mar 2024 at 20:47:01
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    Sorry, I'm out of ideas on why its happening. It shouldn't be.

  • IPC_ahaas Profile Picture
    1,278 Moderator on 08 Mar 2024 at 19:58:02
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    I deleted the Connections from the Dev Environment, created new Connection References and re-created the Connections, then deleted the old Connection References and relinked the Steps to use the new Connection Refences. I republished all customizations and redeployed it to the Beta Environment. Same issue.

     

    I have an open request with Microsoft to get to the bottom of this. Very frustrating.

  • Pstork1 Profile Picture
    67,165 Most Valuable Professional on 08 Mar 2024 at 15:15:18
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    I didn't share anything with the user running the app other than the app itself.  I did share the app directly with the user instead of using a security group, but I don't think that should make a difference.  The actual connection in that environment is owned by me as the maker.image.png

    Any possibility that an earlier version of the app used those connections directly and then they were removed and a flow with connections was used instead? It may be an old ghost connection that is causing the security prompt.

  • IPC_ahaas Profile Picture
    1,278 Moderator on 07 Mar 2024 at 21:09:16
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    Could it be that I need to share the Connections in the new Environment?

     

    IPC_ahaas_0-1709845643544.png

     

    If I have to add users to the Environment, and assign Security Role, and Share the app, and Share the tables, maybe I have to share the connections? Completely absurd that I need to share each piece of this pie, but I wouldn't put it past Microsoft at this point. 

  • IPC_ahaas Profile Picture
    1,278 Moderator on 07 Mar 2024 at 20:53:57
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    Yes, they were. And you can see on the Flow in the new Environment that they are all the service account:

    IPC_ahaas_0-1709844698379.png

  • Pstork1 Profile Picture
    67,165 Most Valuable Professional on 07 Mar 2024 at 20:42:16
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    In the last screenshot if you click on the ellipses menu next to the SharePoint and the Outlook connection reference do those also have a connection using jarvis?

  • IPC_ahaas Profile Picture
    1,278 Moderator on 07 Mar 2024 at 20:38:04
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    These screenshots are without changing anything.

     

    2) 

    IPC_ahaas_2-1709842473357.png

    IPC_ahaas_4-1709842514648.png

     

    IPC_ahaas_5-1709842552537.png

     

    3)

    IPC_ahaas_6-1709842606701.png

     

    5)

    IPC_ahaas_7-1709842742174.png

    6)

    IPC_ahaas_8-1709843090936.png

    7) Shared the app with a Security Group that has my test user in it.

    IPC_ahaas_9-1709844382504.png


    Security Group:

    IPC_ahaas_10-1709844455828.png

     

    My test user (Tony Stark) still gets prompted to use their account.

     

  • Pstork1 Profile Picture
    67,165 Most Valuable Professional on 07 Mar 2024 at 20:11:01
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    I just did a quick test and was able to use a different account on the connection and the user was not prompted for permissions in the production environment.  Here are the steps

    In the Dev environment

    1) Created a Solution with an App, a Flow, and a Connection Reference

    2) Set the Connection Reference to point to a connection with a different account "jdoe@acmeman.com"

    3) Set the Run Only users setting to use that connection for the connection reference.

    4) Published all Customizations and Exported Solution as a Managed Solution

    In the Production environment

    5) Created a connection using "jdoe@acmeman.com"

    6) Imported the Managed Solution. During Import I picked the existing Jdoe@acmeman.com for the Connection reference Connection

    7) Shared the app with e1test@acmeman.com

    😎 Logged in as e1test in a private browser session and ran the app. No Prompt for connections.

     

    #3, #5, and #6 are the key steps I believe.  #6 will default to the makers connection if one exists in the production environment.

  • Pstork1 Profile Picture
    67,165 Most Valuable Professional on 07 Mar 2024 at 19:26:02
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    Let me do some testing. It may just not work when using a connection in the connection reference set for a service account. I haven't tried that scenario.

  • IPC_ahaas Profile Picture
    1,278 Moderator on 07 Mar 2024 at 19:23:32
    Re: Deployed PowerApp is Prompts for User Connection Authentication

    Deleted and reimported the App again. This time I choose the service account for the Connection Refences.

    The Flow now shows the service account.

     

    IPC_ahaas_2-1709839331133.png

     

    The App STILL prompts me to use my account

     

    IPC_ahaas_1-1709839286791.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete