Hello All,

I am trying to make a copilot that triggers an action that will look into a SQL Server table and return a number. The user communicating with the copilot enters a part number and the copilot is supposed to respond with the quantity on hand for the part number. 

Where my issue is – I can use the “Get Rows” action or “Get Tables” action for SQL server just fine. But when I try to use a power automate flow with the same SQL server connection and credentials, it is unable to create the connection. Is any aware of why this might be the case? 

The connection credentials are the same between the two sources

​Hello All, I am trying to make a copilot that triggers an action that will look into a SQL Server table and return a number. The user communicating with the copilot enters a part number and the copilot is supposed to respond with the quantity on hand for the part number.  Where my issue is – I can use the “Get Rows” action or “Get Tables” action for SQL server just fine. But when I try to use a power automate flow with the same SQL server connection and credentials, it is unable to create the connection. Is any aware of why this might be the case? The connection credentials are the same between the two sources      Read More

​