cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FoxRunner
Level: Powered On

How to add a Parameter in a Button to Run Stored procedure

 

I can run a SP from PowerApps using Flow  when I just pass a Value like this.

'PowerApps-Schaltfläche_2'.Run(6000)     <that One works>

 

But I want to have it dynamic. On my Detailscreen I have a DetailForm and Datacards with the values. But i can't pass it over

It says "Invalid arguments"  The Name of the datacard is "ID" 

 

'PowerApps-Schaltfläche_2'.Run(ID.DataField)    <not working>

PowerApps-Schaltfläche_2'.Run("ID")    <not working>

 

Any Ideas please

Thx Claus

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
FoxRunner
Level: Powered On

Re: How to add a Parameter in a Button to Run Stored procedure

Allright I found a solution bymyself

 

Thing is.. I got the wrong property . So the solution to pass over a parameter is only depending of the content of the datacard

 

'PowerApps-Schaltfläche_2'.Run(ID.Default) 

 

But this hopefully helps helps other people

 

 

 

 

3 REPLIES 3
Super User
Super User

Re: How to add a Parameter in a Button to Run Stored procedure

Could the issue be that Flow is expecting a number and PowerApps is inserting a string from your field? If that is the case then it would look something like this:

 

PowerApps-Schaltfläche_2.Run(Value(ID.Text)) 
FoxRunner
Level: Powered On

Re: How to add a Parameter in a Button to Run Stored procedure

Thx for the Answer.

You are right in terms of the numeric value from the proc. A Bigint parameter is required

 

Your solution was hopeful but it didn't wotk :-(

 

PowerApps-Schaltfläche_2.Run(Value(ID.Text))  

PowerApps-Schaltfläche_2.Run(Value(ID.Datfield))

 

 

FoxRunner
Level: Powered On

Re: How to add a Parameter in a Button to Run Stored procedure

Allright I found a solution bymyself

 

Thing is.. I got the wrong property . So the solution to pass over a parameter is only depending of the content of the datacard

 

'PowerApps-Schaltfläche_2'.Run(ID.Default) 

 

But this hopefully helps helps other people