Forum Discussion

Aurora's avatar
Aurora
Copper Contributor
Jul 17, 2024

Copilot not connecting to SQL Server in Actions

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

 

 

 

 

No RepliesBe the first to reply

Resources