Unanswered

PowerApps - Execute Stored procedure problem

(0) Share

Report

Posted on by Community Power Pla...

Hello

When try to execute a stored procedure sql server with parameter from PowerApps i get this error

Unable to process template language expressions in action 'Execute_stored_procedure' inputs at line '1' and column '1547': 'The template language expression 'parameters('$connections')['shared_sql']['connectionId']' cannot be evaluated because property 'shared_sql' doesn't exist, available properties are ''. Please see https://aka.ms/logicexpressions for usage details.'.

Same flow with recurrence first step works fine

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

v-monli-msft on at

Like (0)

Report

Hi compksoft,

Could you please provide us a screenshot of the flow you're trying to build?

Regards,
Mona Li

Was this reply helpful? Yes No
compkos 20 on at

Like (0)

Report
ALTER PROCEDURE [dbo].[SGPCustomersYearUnits] @CustomerCode as varchar(50) AS BEGIN delete from STGCustomersYearUnits; insert into STGCustomersYearUnits select newid() ID, SGCustomersYearUnits.* from SGCustomersYearUnits where CustomerCode=@CustomerCode order by CustomerCode ; END

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Based on this thread, Microsoft have released a fix for this in Preview.

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Execute-Stored-procedure-with-On-Premises-Gateway-server/m-p/9419

Was this reply helpful? Yes No