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)

Sort by

BCBuizer 22,821 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

thank you!!!!

Was this reply helpful? Yes No
BCBuizer 22,821 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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