Forum Discussion

adamsellsnj's avatar
adamsellsnj
Copper Contributor
Oct 31, 2022

Formatting for Visible

I am having trouble getting the formatting correct.  I have a "choice" field in a list on sharepoint.  I am trying to make an "if" statement that looks at that field such as:

 

If(ThisItem.'RequestType'="Commission Invoice", true, false)

 

but it's giving me an error (I believe because the RequestType field is a choice field, not text?  Any suggestions? THank you

PowerApps
sharepoint

6 Replies

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Oct 31, 2022

    adamsellsnj Use below formula for Visible property in Power apps: 

     

    If(ThisItem.'RequestType'.Value = "Commission Invoice", true, false)

     

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    • adamsellsnj's avatar
      adamsellsnj
      Copper Contributor
      Oct 31, 2022

      ganeshsanap thank you. If I want to embed another if statement in there, so 2 pieces of criteria have to be met to be true, or it’ll show fake, how would I. Do that?

       

      • ganeshsanap's avatar
        ganeshsanap
        MVP
        Oct 31, 2022

        adamsellsnj For example: 

         

        If(ThisItem.'RequestType'.Value = "Commission Invoice" && ThisItem.Title = "Item 1", true, false)

         

        This will return true only when both condition 1 AND condition 2 are true. 

        Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources