cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
simonmumby
New Member

Issue sharing Data Connections

I have a bit of a strange issue here when sharing Data Connections in PowerAutomate. I can share SQL Connections absolutely fine with people in my organisation (example below) however if I try to share any other types of Data Connections that I create in the same environment not only can I not search or find employees. If I try to force it and add the email manually it displays this error 'The permission with id '/providers/Microsoft.PowerApps/apis//connections//permissions/' in the put collection requires either the id or the email for the principal.'


SQL connection sharing working here...

simonmumby_0-1655287290757.png
Other connections do not work when attempting to share...

simonmumby_1-1655287373289.png

When I attempt to add the email manually...

simonmumby_2-1655287426216.png

 

 

7 REPLIES 7
tarcisiosp
Helper I
Helper I

Did you find a solution for it?

I'm having exactly the same issue.

simonmumby
New Member

Unfortunately not @tarcisiosp - as an interim solution I have created all the data connections under our service account so we have to login to that single account to create connections, flows, releases etc. Hopefully we can find a better solution soon!

jparizotto12
New Member

Hey all, any news about this issue? Having the same here 😣

 

jparizotto12_1-1655913142295.png

 

 

 

simon_c
New Member

I've run into the same error message attempting to share a SharePoint connection internally today.   I've opened a support ticket for more investigation with the Power Automate team. 

tarcisiosp
Helper I
Helper I

After opening a ticket with Microsoft we figured out that this connector is a non-shareable connector so a new connection needs to be created by each user, so the user needs to have permission to create connection in the Data Gateway. This is the only way we could make it work. Our goal was to use a service account but it’s not possible.

Working with Microsoft and the engineer acknowledged an apparent issue with the People Picker field and that it doesn't appear to resolve any users in the directory.   

That lack of directory lookup, plus the "...put collection requires either the id or the email for the principal.'" context of the error message might suggest that it's unable to share due to that lack of resolution. 

As a workaround, we were able to deploy the app and work with the users who were initially prompted to establish a connection, and then we updated those connections to change the account from their personal credentials to the credentials needed for the connection.  Obviously not a good solution, but the investigation into the underlying cause for the share issue is still ongoing. 

Thank you so much @simon_c ! If you could, please keep us updated, really appreciate! Kudos for you 👏

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (8,394)