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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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 69,125 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!

Thank You!

Was this reply helpful? Yes No
Ensemble 5 on at

Like (1)

Report
Copy link

Link copied!

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