The key didnt match any rows in the table - On prem SQL - Stored Procedure - Power Automate - Power Apps

(0) Share

Report

Posted on by Suresh1409

I am trying to call a Stored Procedure from Power Apps through Power Automate and gives the below message

I have gone through several threads in this forum related the issue but could find a solution that worked for me.

The key didn't match any rows in the table.
inner exception: The key didn't match any rows in the table.
clientRequestId: 12e5d8b2-8701-4174-a5b3-1a9e7c4ec9e9

Appreciate anyones help

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show us the actual stored procedure action you are calling and the parameters declaration in the stored procedure. I suspect this means that one of the parameters you listed for the stored procedure is miss-named.

Was this reply helpful? Yes No
Suresh1409 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Pstork1,

Please find below SP
USE [Project_Dev]
GO
/****** Object: StoredProcedure [dbo].[GetRNumber]    Script Date: 28-Feb-20 16:56:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[GetRNumber]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
    -- Insert statements for procedure here
SELECT FORMAT(GETDATE() , 'MMM') + '-'+ convert(varchar(50),(NEXT VALUE FOR R_Number)) AS RNum;


END

Was this reply helpful? Yes No
db1989 30 on at

Like
a
(0)

Report
Copy link

Link copied!

@Suresh1409 check that you have the right connection in place. It fixed my issue.

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Since you aren't using any parameters, does the stored procedure run correctly when you execute it manually inside SQL management studio?

Was this reply helpful? Yes No