Switch Function with Between Values

(0) Share

Report

Posted on by tlevine

230

Hi - struggling to get this right, any thoughts?

Trying to take the value of a text input box and evaluate it using the switch funciton

Text(
 Switch(
 Value(SupportNeeded_23.Text),
 Value(SupportNeeded_23.Text) >= 0 && Value(SupportNeeded_23.Text) <= 10,
 0,
 Value(SupportNeeded_23.Text) >= 11 && Value(SupportNeeded_23.Text) <= 20,
 5,
 Value(SupportNeeded_23.Text) >= 21 && Value(SupportNeeded_23.Text) <= 30,
 8,
 Value(SupportNeeded_23.Text) > 30,
 11
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @tlevine ,

A switch function only works for exact matches of the outcome of the formula (first argument): https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-if

Instead of a Switch()function you need to use If():

Text( If( Value(SupportNeeded_23.Text) >= 0 && Value(SupportNeeded_23.Text) <= 10, 0, Value(SupportNeeded_23.Text) >= 11 && Value(SupportNeeded_23.Text) <= 20, 5, Value(SupportNeeded_23.Text) >= 21 && Value(SupportNeeded_23.Text) <= 30, 8, Value(SupportNeeded_23.Text) > 30, 11 ) )

Was this reply helpful? Yes No
Verified answer

tlevine 230 on at

Like (0)

Report

thank you!!!!

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @tlevine ,

Happy to read this resolved your issue. Can you please mark the right post as the solution so it's easier to find for other members of the community?

Was this reply helpful? Yes No