Forum Discussion

Copper Contributor

Oct 30, 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.'Request...

PowerApps

sharepoint

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.

adamsellsnj

Copper Contributor

Oct 31, 2022

Thank you! I can use this for the value from a choice as well? Does it have to be a text column?

ganeshsanap
MVP
Oct 31, 2022
adamsellsnj You can use AND/OR for any column types.

Inside single condition, formula depends on your column type and column settings. You have to use .Value like (ThisItem.'RequestType'.Value) to get the actual text value of single selection choice column. But for text columns, you can directly use column name to compare like (ThisItem.Title).
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.