Flow response not showing correctly in PowerApps

(0) Share

Report

Posted on by HFG

524

Hi all,

I have a Flow that returns an error code and message to PowerApps using a SQL stored procedure. The Flow is running correctly and returning the correct error message and code, however, in Powerapps the code coming through is not correct. Please see attached screen shots. In the example the correct code 2 is showing in Flow, but 0 is coming through in PowerApps.

Any ideas why?

Thanks

PowerApps code er...

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Pstork1 69,651 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Try using Text() instead of Value() for your printout. Value() converts text to a number and Text() converts a number to Text. Since you are concatenating you want to convert the errorcode to a string, not a number.

Was this reply helpful? Yes No
HFG 524 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1 ,

Thanks for your reply.

When I try Text() the number disappears completely, the same if I simply put varUpdateResponse.number.

This label was actually just a test to see what was being returned. I am using the value to show an error message (see below). Currently I am having to use <>0 as it does not work if I do >0. This is working which is also strange as from the label it suggests that PowerApps is getting 0 back from Flow.

If(
varUpdateResponse.number<>0
,Notify(varUpdateResponse.error_message,NotificationType.Error);

Was this reply helpful? Yes No
Pstork1 69,651 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I think the key here is to take a look at the Schema in the input section of your respond to Powerapps. You can see in my test the error number is coming back as text.

So I store that return value as a table in a variable and then just concatenate the results in Powerapps and it works.

The other potential problem might be your use of Terminate - Fail. That may interfere with the Respond to PowerApps.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @HFG ,

Could you please share a screenshot about your whole flow's configuration?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

Flow's configuration as below:

Please check if the varUpdateResponse variable within your app contains a proper number value.

I have reproduced your issue on my side, if you defined a Number output within your "Respond to PowerApps" action, but you provide a String value for it, when the flow return data back to your app, the Number output property would be Blank, then the Value(NumberOutput) would be 0.

Please make sure the Output variable you defined in your "Respond to PowerApps" action and the corresponding value you provided for it have same data type.

Best regards,

Was this reply helpful? Yes No
HFG 524 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft,

Thanks for looking into this.

Here is my full Flow. I have also checked the variable in PowerApps and the data type is showing as Number.

Cheers

Flow.pdf

Was this reply helpful? Yes No
HFG 524 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1 ,

Thanks again for looking into it. In the Schema of my Flow the number is correctly coming back as number...strange

FlowSchema.pdf

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @HFG ,

Do you add a Condition action after the "Respond to PowerApps" action in your flow?

Based on the flow's configuration that you provided, I think there is something wrong with it. If you want to pass data from a flow back to an app using the "Respond to PowerApps" action, you should define the "Respond to PowerApps" action as last action in your app.

Please consider remove the actions (condition action) under the "Respond to PowerApps" action within your flow, then re-save your flow, try the formula again, check if the issue is solved.

In addition, please make sure the ReturnCode dynamic content from the "Execute SQL procedure (V2)" action is also a Number value. You could also consider use int() function to convert the ReturnCode dynamic content value into a number value as below:

set the value box for the number output to following formula:

int(body('Execute_stored_procedure_(V2)')?['returncode'])

Please take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
HFG 524 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft,

I have just added a similar Flow to another part of my app and with the below solutions - removing the conditions and using the int() function in Flow - the correct values for the error code are now being returned to PAs.

Thanks!

Was this reply helpful? Yes No
HFG 524 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi again,

In case it is useful to anyone, a colleague pointed out that if the int() expression works, it's because Flow was expecting a text for the error code. I guess that is what you were all trying to tell me! We tested choosing text for the error code output and that also works (even if it seems a little strange when the error code is a number!).

Was this reply helpful? Yes No