Answered

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

(0) Share

Report

Posted on by littletinner

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?

Categories:

Building Power Apps

Capture.PNG

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

PaulD1 2,914 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
littletinner 17 on at

Like (0)

Report

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

Was this reply helpful? Yes No