[CoE Starter Kit - QUESTION] See connection usage per environment

[mdhauck]

What is your question?

In the Power Platform Admin View app looking at connectors. Can someone point me to documentation or elaborate on the underlying schema. I see almost 700 "active connectors" but the vast majority don't show an environment. If I look at one (Sharepoint as example) that I know is used, I can see from the subgrids it is in 46 Apps and 258 Flows but the environment column/field is locked and blank. Shouldn't there be a 1:N relationship from connector to environment? It would be very helpful to see all the environments that a connector is used in as I don't see this info by opening an app or flow on this form (I have to drill down)? Thanks as always (you all are doing an AWESOME job with this)!

What solution are you experiencing the issue with?

Core

What solution version are you using?

No response

What app or flow are you having the issue with?

Power Platform Admin

[Jenefer-Monroe]

Thanks for your kind words!

First let's resolve the confusion about this table. This table shows the connectors (not the connections) in your tenant. Most connectors (ex SP) are available in all environments (though they might be restricted via DLP). It's only the Custom Connectors that are members of an individual environment:

Regarding your desire to see the connector usage by environment. The information mapping connector to apps/flows stored in the CoE Connection Reference table and we expose it in a few places. First of all in the subgrids in the app as you meantion, though we don't show the envt there. But also in the PowerBI on the Cloud flow Connections and App Connections pages

Please let me know if this answers your question or if you have something else in mind.

[mdhauck]

First of all thank you for the clear explanation. It kind of answers the question but I have a few follow ups: in the sharepoint connector screenshot - 1) COULD environments be added and 2) why is their a (locked) environment field there - is that (only) for the custom connectors that are environment by environment. I THINK the Power BI report may solve the issue (for some reason my id doesn’t have access in clients environment - assuming it is licensing issue) but it wasn’t obvious to me what the underlying table/relationship structure looks like. I was able to create some advanced finds (on connection references and app connectors) that I believe is showing the app (or flow) and the environment. Was just wondering of intent and if others are asking to see env by env list or if our request is unusual/unique?

[Jenefer-Monroe]

We are a little constrained on space there so the envt wont really fit. But yes the environment field is just for custom connectors :)

[Jenefer-Monroe]

closing out as no further action for starter kit team