Unanswered

Using a Variable in an If Statement

(0) Share

Report

Posted on by ACPBSCi

222

Upon creation of a record, I set a global variable called "varRecord". By using this and a ".________", I can utilize all the values in all the fields of the record. For example, varRecord.'Account Name' or varRecord.'Launch Date'.

I want to hide a button if the program type equals "ABC Program", but I can't figure out the expression. This expression does not work:

If(equals(VarRecord.'ProgramType'("ABC Program"),true),false, true)

I feel like I'm close. What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report
Try the following in the Visible property of the button.

If(equals(VarRecord.'ProgramType',"ABC Program"),false, true)

Was this reply helpful? Yes No
ACPBSCi 222 on at

Like (0)

Report

No, that's not working either.
I wish the "get help for this error" feature was actually helpful. All it says is that the "If" has some invalid arguments. You think?
Your recommendation makes sense. The syntax makes sense. Is there something different I need to do because of the type of global variable I'm using and the way I'm using it (varRecord.'Program Type')? Am I not able to use it this way?

Was this reply helpful? Yes No
Verified answer

StormEAnderson 60 on at

Like (0)

Report
It may be because 'Program Type' is a choice field, in which case you are not dealing with a string but a record. If that is the case you would need to use the "Value" property within that record. So try either of the following:
// If the field is a choice / lookup field Not(VarRecord.'ProgramType'.Value = "ABC Program") // --- evaluates to FALSE when programType is equal to "ABC Program" // If the field is a text field Not(VarRecord.'ProgramType' = "ABC Program")

Was this reply helpful? Yes No
ACPBSCi 222 on at

Like (0)

Report

GOT IT!
Not(VarRecord.'Program Type' = "ABC Program")
There is a space in "Program Type". Gotta use those suggestions when they pop up. You can't trust that you know exactly how it appears.

Was this reply helpful? Yes No