Same flow not returning same response between environments

(0) Share

Report

Posted on by JamesSolan_

Hi guys,

I have a solution in Dev containing a powerapp, SQL connection and Flow.

The powerapp views data with a sql connection. After viewing the data, the user can then send parameters to the flow, which triggers a stored procedure. This uses the same sql connector. The results of the stored procedure are then passed back to the powerapp as a response, the powerapp then displays a messaged based on the response.

After I've exported the solution to UAT via pipelines, The powerapp can view data, pass exactly the same parameters to the flow and stored procedure, but receives a blank payload back.

I'm at a loss to figure out where its going wrong. Is this a Power platform thing or a database thing?

Thanks in advance,

James

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

RampalsT 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Try to debug you app and flow to see where the error resides.
For the app, go to edit-->advanced tools open monitor --> click the button and read in the Run operation what response it receives from the flow.
For the flow open its last run and check that all is working correctly.

Tell me how it goes. If the flow works correctly maybe its power apps that don't receive its response. In that case tell me.

Hope it helps.
JamesSolan_ 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ram,

I looked at that - I'm afraid there isn't anything from the monitor that reports as a fail. From the Power automate flow, everything runs successfully, just it receives null as a payload rather than any values from exactly the same input parameters as the dev version 😑
RampalsT 75 on at

Like
a
(0)

Report
Copy link

Link copied!

So its the flow the one that receives the null value, or the app?