Switch function: Is it possible to have a match value equal to a date range.

(0) Share

Report

Posted on by Community Power Pla...

Hello, I have never used Switch function before. For the sake of explanation, I have simplified the formula.

Switch(MyVariableName, DateAdd(Now(),-30,Months), "Inactive","Active" )

The code works, but the DateAdd(Now(), -30, Months) returns a value of the specific date 30 months ago.

Is there a way with the switch function to implement code like the if statement? I would use <=Today() for an IF statement. I cannot use it with the Switch function.

Example(Switch(MyVariableName, <=Today(), "Inactive","Active" ) gives an error.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

Unfortunately, No. Switch can only be used to check equals with a case sensitive value.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank You!

Was this reply helpful? Yes No
Ensemble 5 on at

Like (1)

Report

You can get a similar functionality with a switch statement like so...

Switch(true,
ThisItem.Date > Now(),
"Future",
ThisItem.Date = Now(),
"Today",
ThisItem.Date < Now(),
"Past"
)

A switch statement can only match a single value. This works by matching the value 'true' to the output of the conditions. Hope this helps.

Was this reply helpful? Yes No