Share
Report
35Hi All -
I've got a power automate flow that I'm using to pull data from SQL tables and views and distribute them to key individuals. I've had no trouble doing this up to this point, and now I'm getting an error.
I created a new view today, and it won't show up in the pre-populated list in the SQL Get rows (v2) action in my flow. All other views and tables do, and I've already confirmed that the credentials I'm utilizing have access to this view.
I get the following error:
Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: 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: acf24fd7-78f4-41fb-92b0-a80847412add", "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": "sql-ncus.azconn-ncus-001.p.azurewebsites.net" }
Here are the columns in the view.
It's a view, so it doesn't have a primary key, but the Index column has no duplicate values in it.
The thing that is different for this view compared to the others that do show up in the pre-populated list is that this new view is built from a join. Is that a limitation?
Any help is appreciated. Thanks.
All responses (
Answers (
