cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

'Execute Stored Procedure' Flow requires 4 arguments in 1 App and 5 in another.

I have an 'Execute Stored Procedure' Flow that requires 4 arguements.  It works fine one app, as far as requiring only 4 arguements.  But in another, it requires 5...and thus errors out when I don't provide it a 5th.

I have tried to remove/reapply the flow at both a 'View > Data Sources' level and a button level, without success in the 2nd App.

 

I tried to create a new flow to see if the Stored Procedure was somehow changed, but it still only requires 4 arguements when I get to that step in the process.

 

Currently, I am 'cheating' it in the 2nd App by adding a 5th (blank - "") argument (i.e. SMAppWorkorder_Update.Run(ThisItem.Barcode,"Status2","SMflow","Complete","") and it seems to be working.  But, I don't like that as a longterm solution.  Anyone encounter this inconsistency between multiple apps?  Is this a momentary bug?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: 'Execute Stored Procedure' Flow requires 4 arguments in 1 App and 5 in another.

Is the following possible?

You created the Flow with 4 arguments (Ask in PowerApps) and added it to your 1st PowerApp. All works as you expect.

Later you modified the Flow so there is a 5th argument (note, when you hit 'Ask in PowerApps' that argument is added to the trigger - even if you later remove that argument, or even the whole step containing the argument, you can never get it out of the trigger).

You then created PowerApp 2. When you 'imported' the Flow, it specified 5 arguments, so that is what you are asked to complete a 5th argument.

Note that adding a new argument to the Flow will not affect PowerApp 1. When the Flow was added it had 4 arguments and that is all the PowerApps will 'see' unless you remove and re-add the Flow. It is only when you add a Flow that the arguments are brought in.

To fix the Flow (so it only has 4 arguments) you'll probably need to recreate it and then replace the existing Flow in both of your PowerApps.

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: 'Execute Stored Procedure' Flow requires 4 arguments in 1 App and 5 in another.

Is the following possible?

You created the Flow with 4 arguments (Ask in PowerApps) and added it to your 1st PowerApp. All works as you expect.

Later you modified the Flow so there is a 5th argument (note, when you hit 'Ask in PowerApps' that argument is added to the trigger - even if you later remove that argument, or even the whole step containing the argument, you can never get it out of the trigger).

You then created PowerApp 2. When you 'imported' the Flow, it specified 5 arguments, so that is what you are asked to complete a 5th argument.

Note that adding a new argument to the Flow will not affect PowerApp 1. When the Flow was added it had 4 arguments and that is all the PowerApps will 'see' unless you remove and re-add the Flow. It is only when you add a Flow that the arguments are brought in.

To fix the Flow (so it only has 4 arguments) you'll probably need to recreate it and then replace the existing Flow in both of your PowerApps.

View solution in original post

Highlighted
Frequent Visitor

Re: 'Execute Stored Procedure' Flow requires 4 arguments in 1 App and 5 in another.

I hadn't modified it, but i did have to recreate it to fix it.  I just 'saved as.'  Thanks.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,067)