Skip to main content

Notifications

Power Apps - Power Apps Governance and Administ...
Unanswered

Change ownership SQL connection

(0) ShareShare
ReportReport
Posted on by 20

One of our developers who is the owner of this connection on PowerApps does not work with us anymore.
He is still the owner of the SQL connection.
How do i change the ownership to me?

aftabp_0-1705485259423.png

 

Categories:
  • AlbertoCastro Profile Picture
    AlbertoCastro 1,176 on at
    Re: Change ownership SQL connection

    Yes, you can use the connector Power Apps for Admin to retrieve connecion information and edit the permissions:

     

    https://learn.microsoft.com/en-us/connectors/powerappsforadmins/

    https://learn.microsoft.com/en-us/connectors/powerappsforadmins/#edit-connection-role-assignment-as-admin

     

  • aftabp Profile Picture
    aftabp 20 on at
    Re: Change ownership SQL connection

    i am very new to this so here are a few questions:
    where do i find all the GUIDs?
    is there a way to do it with Flows?

  • AlbertoCastro Profile Picture
    AlbertoCastro 1,176 on at
    Re: Change ownership SQL connection

    Hi,

    you could change the owner from powershell:

    Set-AdminPowerAppConnectionRoleAssignment -PrincipalType Group -PrincipalObjectId [Guid] -RoleName CanEdit -ConnectionName [Guid] -ConnectorName shared_vsts -EnvironmentName Default-[Guid]

    -------------------------------------------------------------------------
    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    Regards
    Alberto

     


    https://learn.microsoft.com/en-us/powershell/module/microsoft.powerapps.administration.powershell/set-adminpowerappconnectionroleassignment?view=pa-ps-latest

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics