Unanswered

Text Switch with Calculate

(0) Share

Report

Posted on by JSeymour

Hi,

I have a Text Label that takes the value of a dropdown box in a form and assigns it a certain value based on the selection:

Text(Switch( ValueCount.Selected.Value, "0-5", 1, "6-50", 2, "51-100", 3, "100+", 5, 0), "0")

However, if the dropdown has multiple values, I would like them to be added together. So if "0-5" with a value of 1 is selected and "100+" with a value of 5 is selected, then the text label displays 6 rather than the most recently selected item.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi @JSeymour ,

A DropDown does not allow for multiple selections, but what you can do is to replace it with a ComboBox.

The set the Text property of the label to:

Sum( ForAll( ComboBox.SelectedItems, Switch( ThisRecord.Value, "0-5",1, "6-50", 2, "51-100", 3, "100+", 5, 0 ) ), Value )

Was this reply helpful? Yes No
JSeymour on at

Like (0)

Report

Ah yes! Sorry I was indeed using a combo-box not a dropdown, my bad. That worked perfectly, thank you for your help 🙂

Was this reply helpful? Yes No