cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

SQL Server Stored Procedure Issue

Hi,

 

I used to run a flow in my powerapps with no problem. I am running a flow that executes a stored procedure, with one parameter, when the stored procedure is run in SQL it has no issues. Now when I try to create the flow again it comes up with the following error when I add the "Ask in PowerApps" to the parameter value:

 


The key didn't match any rows in the table. inner exception: The key didn't match any rows in the table.
clientRequestId: 6AF44C61-0FCA-4E4A-858E-891679B50C17

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

Hi @  JackBerryWorld,

 

Could you please share a screenshot of the configuration of your flow?

 

Could you please share more details about your issue?

The error message told that the key didn't match any rows in the table.

 

Please share more details so we could provide a proper workaround for you.

 

 

Regards,
Alice Zhang

Anonymous
Not applicable

Flow.jpgThat is the whole flow and the proc runs successfully in SQL, what other details would help?

 

Kind regards,

Jack

Anonymous
Not applicable

Flow.jpgThat is the whole flow and the proc runs successfully in SQL, what other details would help?

 

Kind regards,

Jack

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (10,380)