Sql Server Trigger with Power Automate

Question

Hello,

My team recently built a sql server gateway connection however when changing the display name we encountered the following error.

"The URI `` is not from a trusted source. "

I decided to proceed with setting up the flow to see if the connection is established however when setting the trigger It doesn't auto populate table name for the connection nor does it populate any dynamic content. Upon entering a custom value for the table name and saving the flow the following error occurs. Please advise.

"Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sql' operation 'GetTable_V2' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "The key didn't match any rows in the table.\r\n inner exception: The key didn't match any rows in the table.\r\nclientRequestId: ", "error": { "message": "The key didn't match any rows in the table.\r\n inner exception: The key didn't match any rows in the table." }, "source": "" }'."

Answer 1

Dear Bio,

Please first see Bkeano's suggestion in The key didn't match any rows in the table - Power Platform Community (microsoft.com) to see if there are some improvements in your environment.

Thank you for your effort and time!

Sincerely

Cliff | Microsoft Community Moderator