Forum Discussion

zlasek's avatar
zlasek
Copper Contributor
Jul 17, 2023
Solved

PowerApps: Using Buttons to Update Existing Records

Hello,   I am trying to use buttons to populate my "ApprovalDecision" column instead of having the user type in "yes" or "no". I am new to PowerApps so I am unsure how to do this. This screenshot s...
button
excel
PowerApps
  • SvenSieverding's avatar
    SvenSieverding
    Jul 18, 2023

    Hi zlasek 

     

    you already have a form "Form1" with the "ApprovalDecisionDatacard1"


    Select that card and select "Unlock to change properties" on the right side

     

    The create a new Button "Approve" and set it's OnSelect Property to 

     

    Set(varApprovalResult,"Yes")

     

    and another Button "Reject" and set it's OnSelect Property to 

     

    Set(varApprovalResult,"No")

     


    Then select the ApprovalDecisionDatacard1 and set it's Default Property to "varApprovalResult"

    and the Property "Visible" to false


    This should be enough to fix your usecase.

    But you should also initialize the "varApprovalResult" variable in the "On Visible" property of your screen "Details" like

    Set(varApprovalResult,BrowseGallery1.Selected.ApprovalDecision)

    and enable/disable your "Approve"/"Deny" buttons by using this formula in their "DisplayMode " properties

     

    If(varApprovalResult="Yes",DisplayMode.Edit,DisplayMode.Disabled)


    Best Regards,
    Sven



     

zlasek's avatar
zlasek
Copper Contributor
Jul 18, 2023
This worked perfectly, thank you! Now is there a way to add formatting to the button once clicked to show that it was selected? For example, if a user selects "Approve" the button turns a different color?
SvenSieverding's avatar
SvenSieverding
Bronze Contributor
Jul 18, 2023

zlasek 

Sure, this works like disableing the buton. Set it's "Fill" property to a different color depending on the variable varApprovalResult like this (Sets the button's color to grey, if approved and to green otherwise)

If(varApprovalResult="Yes",Color.Grey,Color.Green)


Or more with more colors

If(varApprovalResult="Yes",Color.Grey,If(varApprovalResult="No",Color.Black,Color.Green))

(Sets the button's color to grey, if approved and to black, if not approved and to green otherwise)

Best Regards,
Sven

Resources