Answered

Can I delete connections in my solution??? Can duplicate connections be deleted???

(0) Share

Report

Posted on by nicktalsma

I am a self-declared newbie when it comes to working with Power Apps. I've been experimenting with the platform over the past few months and have built my first two apps and several flows that work alongside them.

When I first started with Power Apps I was using Excel as a data source, but quickly realized that was not the optimal choice so I switched over to SharePoint. Now I see I have an Excel (Online Business) connection in my solution. I am thinking that may be from my original attempt at creating and app (using Excel as a data source) and thus no longer used, but how can I be sure? What are the implications if I choose to delete that connection from my solution (in the interest of keeping the solution clutter free)? Excel (Online Business) is not listed in either app under the Data section however it is used in my flows.

Similar question with the SharePoint connections. How can I tell what is using them? Why are there two? Do they need to be in the solution? What happens if I delete them from the solution?

...And a related question about the actual connections found on the Connections Tab in Power Apps. Why is SharePoint listed 4 times? Can any be deleted and if so what might be the implications? Breaking one of my apps that I have spent countless hours building is one of my largest fears...

Same goes for the Excel connector being listed 3 times (2 of which appear to be having an issue logging in).

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

OdinDelToro 407 on at

Like (0)

Report
Copy link

Link copied!

Hello @nicktalsma ,

Review the connections and dependencies of the object within the solution to be sure. If the connection you want to remove is not linked to any of the resources it's ok to remove it.
To review dependencies you have to go to the objects and look for the show dependencies section which will show them.
To review the connections you have to go to the details of each object
You'll be able to review the connections there

Hope this helps clarify the doubt, let me know in case you're still facing an issue within it.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
nicktalsma 38 on at

Like (0)

Report
Copy link

Link copied!

@OdinDelToro That was really helpful!

I do see that everything I have listed in that solution is being used by something. The Excel 8cd70 connection reference is tied to my Flow - Database Contacts and Flow - Database Facilities flows. The SP ae03a connection reference is tied to my Clear My SharePoint Recycle Bin flow and the SP b3c44 connection reference is tied to my Flow - Database Contacts, Flow - Database Facilities and sp_power_automate_aru_tracker_export flows. Not entirely sure why both the SP ae03a connection reference and SP b3c44 connection reference need to exist when I only am using a single SharePoint site?

I also clicked on Details > Connections (as you suggested) on one of my apps and saw two connections to the SharePoint site. Why does it require two connections instead of 1?

As you can see below I have 3 lists from my SharePoint site available in the app.

Leaving Solutions for a minute. Any idea why I show 3 Excel Online (Business) connections and 4 SharePoint connections (only the 1st two SP connections are being used by apps/flows per the Details section)?

Was this reply helpful? Yes No
Verified answer

OdinDelToro 407 on at

Like (0)

Report
Copy link

Link copied!

Hello @nicktalsma ,

That happened because while developing and importing the data, there were created multiple connections. Usually you just need one connection.
Please, validate before removing the connections if those connections are not used by any other app. If it's just connected to the app mentioned, then what you can do is first remove the data connected to the app through those connections then save and publish. After that, go to the connections within the details and remove those connections linked to the app. Then go back to the app and connect within a single connection the data from SharePoint.

Hope this helps clarify the doubt, let me know in case you're still facing an issue within it.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No