web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Display return code of...
Power Automate
Answered

Display return code of stored procedure in PowerApp

(0) ShareShare
ReportReport
Posted on by

Hello,

 

I have a button in PowerApps which executes a stored procedure and I want to display a message if the stored procedure was executed successfully or not. I have tried doing this by adding an output but I cannot get the result to be displayed in a text field in PowerApps. 

Has anyone tried this successfully?

returncode.PNG

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    68,898 Most Valuable Professional on at

    Have you tried storing the return code from the Flow in a variable in PowerApps and then binding the textbox to the variable.  As a declarative system PowerApps doesn't normally allow programmatic changes to object properties at runtime.  Usually you have to bind controls to variables and then change the value of the variable.

     YOur run statement should look something like this.

    Set(returnvariablename, Flowname.run(input parameters if any))
  • Community Power Platform Member Profile Picture
    on at

    Hello @Pstork1 ,

     

    This is what I did, but the text field displays no value.  

     

    Set(datafromflow, ExecuteSP.Run())variable.PNGText field.PNG

  • Pstork1 Profile Picture
    68,898 Most Valuable Professional on at

    Did you look at the variable value itself using the menu in the designer to make sure that there was a return code?  That will tell you if its just not binding or if there is a problem saving the return code from the stored procedure and returning it to Powerapps.  It might be a Flow or a SQL issue rather than a PowerApps issue.

  • Community Power Platform Member Profile Picture
    on at

    @Pstork1 ,

     

    where can I see the return code in designer? I can see the data from the below print screen, but I am not sure if it is the right thing. Thank you.retunrcode.PNG

  • Pstork1 Profile Picture
    68,898 Most Valuable Professional on at

    Nope, that's the right place.  But if you look down into the Outputs section you will see that your result code is blank.  Double check your stored procedure to make sure its actually returning a result code.

  • Community Power Platform Member Profile Picture
    on at

    Hello @Pstork1 ,

     

    I have a return code in my procedure but it still does not return anything.

     

    ALTER procedure [dbo].[TESTProc] as
    BEGIN
    SELECT 8/4
    return 1
    END

     

  • CodingCarnage Profile Picture
    3 on at

    @Anonymous  i have this same issue, Did you made it work?

  • Community Power Platform Member Profile Picture
    on at

    Hello @CodingCarnage ,

     

    I used the following solution: 

    In the stored procedure: 
    DECLARE @ResultsTable TABLE (ErrorMessage varchar(500), ErrorCode VARCHAR(10), ReturnData NVARCHAR(MAX), ReturnMessage NVARCHAR(MAX))

    Insert the desired values in the table: 

    INSERT INTO @ResultsTable(ErrorMessage, ErrorCode, ReturnData , ReturnMessage)
    VALUES ('1', '2', '3' , '4');

    at the end of the stored procedure:

    SET @JSON_OUTPUT= (SELECT ErrorMessage, ErrorCode, ReturnData , ReturnMessage from @ResultsTable FOR JSON AUTO, INCLUDE_NULL_VALUES )
    end

     

    In MS Flow use a parse JSON after the execution of the stored procedure:

    https://ibb.co/w7cH6Rz

    Put this in schema:

    {
        "type""array",
        "items": {
            "type""object",
            "properties": {
                "ErrorMessage": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ErrorCode": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ReturnData": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ReturnMessage": {
                    "type": [
                        "string",
                        "null"
                    ]
                }
            }
        }
    }
    Add a respond to a PowerApp or Flow node: https://ibb.co/0KPwPgm
    Then you call the flow in PowerApps UpdateContext({flowResult: Flow.run(parameters of flow)})
    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard