web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Text Switch with Calcu...

Power Apps

Answered

Text Switch with Calculate

(0) Share

Report

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 Img

All responses (2)

Answers Img

Answers (1)

Verified answer

BCBuizer 22,535 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

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

Link copied!

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

Join the conversation