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

All responses (3)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: PowerApps - Execute Stored procedure problem

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
compkos 20 on at

Like (0)

Report
Re: PowerApps - Execute Stored procedure problem

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
v-monli-msft on at

Like (0)

Report

Re: PowerApps - Execute Stored procedure problem

Hi compksoft,

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

Regards,
Mona Li