[CoE Starter Kit - Feature]: Store Connection status #3299
Description
Is your feature request related to a problem? Please describe.
We have recently started storing connection identity information to report on cross-tenant connections - another use case for this information is to identify if an environment contains broken/unauthorized connections and help with the clean up.
The Get Connections as Admin returns this information
Connected returns:
"statuses": [
{
"status": "Connected"
}
Broken connection:
"statuses": [
{
"status": "Error",
"target": "token",
"error": {
"code": "Unauthorized",
"message": "Failed to refresh access token for service: oauth2generic.
Describe the solution you'd like
Expand the Connection Identity table to store the status information and maybe the error message or some detail around that.
There is a Remove Connection as Admin capability as well so we could look at how to clean up broken connections - what does the process look like?
https://docs.microsoft.com/en-us/connectors/powerappsforadmins/#remove-connection-as-admin
Describe alternatives you've considered
No response
Additional context?
No response