cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stapes
Level 8

How do I enter Parameters for a Stored Procedure called from a Flow?

I have created a flow that uses an SQL Stored Procedure with a number of parameters.

 

RollCallDate.PNG

 

 

I am trying to use this in a Canvas App.

Using the OnSelect action of a button, I am trying to run this:

 

ClearCollect(newCollection, RollCallDate.Run(TextInput1.Text))

 

The Tool has underlined this with a wriggly red line, and the tooltip says 'Invalid number of arguments: received 1, expected 0'.

 

So how do I pass these parameters?

 

RunParameters.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: How do I enter Parameters for a Stored Procedure called from a Flow?

Hey @stapes 

 

First you need to add the variable in Flow. Use dynamic Content and select "Ask in PowerApps" under PowerApps action. This needs to be done passed as a string value.

Now, remove the flow from the app and register it again.
You should be able to see the variable created in the flow. Pass the value and this should resolve your error.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

1 REPLY 1
Dual Super User
Dual Super User

Re: How do I enter Parameters for a Stored Procedure called from a Flow?

Hey @stapes 

 

First you need to add the variable in Flow. Use dynamic Content and select "Ask in PowerApps" under PowerApps action. This needs to be done passed as a string value.

Now, remove the flow from the app and register it again.
You should be able to see the variable created in the flow. Pass the value and this should resolve your error.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

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!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (4,749)