Forum Discussion

zlasek's avatar
zlasek
Copper Contributor
Jul 17, 2023

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



     

SvenSieverding's avatar
SvenSieverding
Bronze Contributor
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