I’ve built a Copilot Studio agent that uses Power Automate flows, and the flows in turn connect to a SQL connector to fetch data.
When I publish the agent to Microsoft Teams and share it with other users by adding them as viewers (and sharing the Teams channel link), they are able to access and interact with the agent. However, when the agent triggers a flow, those users are prompted to“Manage connections”. When they try to do so, they get an error indicating that they don’t have access to the environment.
My question is:
- Is sharing the agent in Teams sufficient, or
- Do users also need some level of access to the Power Platform environment where the flows and SQL connections reside (even if they are only consuming the agent and not editing anything)?
I’d like to understand the minimum required environment / connection access for end users when an agent uses Power Automate flows with SQL connectors.

Report
All responses (
Answers (