cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

 

 

 

 

View solution in original post

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)) 


--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
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

 

 

 

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 361 members 6,663 guests
Please welcome our newest community members: