web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to use If Statemen...

Power Apps

Unanswered

How to use If Statement for a text choise option in Share Point list?

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have been trying to use an IF statement

If LineItemStatue is "Closed" (which is a multiple choise option) then in the Permanent Solution I must get a specific statement, and I have been trying with the below, but its not helpng,

If(Line Item Status.Field = "Closed", "Permanent Solution is Mandate", "Once Line item closed please fill this column")

I get an error if I try this, "Sorry we couldn't edit the column. Please try again."

Please let me know where I'm going wrong.

Thank you!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

RobGas 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, you have to reffer to the choices name for example i have choice selection called "Fruit" in the choice i have "apple", "banana", "orange" so it would have to be like this
If(Line Item Status.Field = Fruit.apple, Fruit.banana, Fruit.orange)
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Where are you using this code ? If it is the Default of a control in a Form, you would need

If( "Closed" in ThisItem.LineItemStatus.Value, "Permanent Solution is Mandate", "Once Line item closed please fill this column" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Join the conversation