Hello,
We have an on-premise SQL Server 2012 SP3 database which has an insert stored proc which we are trying to run from Flow.
When we run the stored proc we get error 'The key didn't match any rows in the table'.
There are unique keys which are autogenerated and work properly. We have tested and used this stored proc hundreds of times outside of flow.
The permissions to access SQL Server appear to be ok as we have gone into SQL Profiler and confirmed Flow is hitting the db. We can see activity going against Sys tables to get the param info on stored procs.
We have also created a second, simpler stored proc with no parameters (just to test the params are not the issue) and that is getting the same error message.
We'd really like to use PowerApps and Flow with our on-prem SQL Server but there are constant roadblocks: cannot do inserts against views, can't have auto inserts/updates/deletes against tables with triggers so need to use stored procs. Now trying to use stored procs and getting errors. Hope someone can help!
Any help sincerely appreciated.
Thanks,
Dan
