Unanswered

Modern Control Combo Box choices

(1) Share

Report

Posted on by CT-07020114-0

Hi All,

I'm creating an work intake form that has several different combo box drop downs such as Business Scale, Frequency, Effort Reduction, etc. where the choices are the same (High, Medium, Low) and each choice has a numerical value. Once the end user has selected all required fields I need to calculate a total based on the different user selections. I'm running into the incompatible type error and am having a hard time figuring out the best way to solve for this while keeping my data linked to the Dataverse table. Any ideas?

Example:

Dropdown 1	Dropdown 2	Dropdown 3	Dropdown 4	Dropdown 5	Dropdown 6	Total
High	Medium	High	Low	Low	Medium	12

Choice	Value
High	3
Medium	2
Low	1

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

ronaldwalcott 3,866 Moderator on at

Like (0)

Report
Copy link

Link copied!

What incompatible type error are you running into?

Do you have two Dataverse tables which are linked by some field or did you use a Dataverse choice field?

If you used a Choice field you could create Formula columns on the table so that you can access the values as numeric similar to this

Choice columns in Dataverse are created with a Label and a Value

To create a Formula column based on a Choice columns, with a choice column called TestChoice, you can use the value item with the Value function.
If(Value(ThisRecord.TestChoice) = 696680000,"yyy","nnn")
This function would be entered in the formula field of a Formula column.

Need some more information on how you have it configured

Was this reply helpful? Yes No
CT-07020114-0 2 on at

Like (0)

Report
Copy link

Link copied!

@ronaldwalcott

I have 6 different column choices that each have the high, medium, low choices and the values of 3, 2, 1. I then have a different column named Stakeholder Total that's a modern text input. I'm trying to have the total "score" calculated based on what the end user selects in the drop downs.

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

You're running into the incompatible type error because ComboBox.Selected returns a record instead of a plain value. You need to extract the selected value properly before using it in calculations.

Use a Switch() function to assign numerical values to each selected option.

With(
{
score1: Switch(ComboBox1.Selected.Value, "High", 3, "Medium", 2, "Low", 1, 0),
score2: Switch(ComboBox2.Selected.Value, "High", 3, "Medium", 2, "Low", 1, 0),
score3: Switch(ComboBox3.Selected.Value, "High", 3, "Medium", 2, "Low", 1, 0),
score4: Switch(ComboBox4.Selected.Value, "High", 3, "Medium", 2, "Low", 1, 0),
score5: Switch(ComboBox5.Selected.Value, "High", 3, "Medium", 2, "Low", 1, 0),
score6: Switch(ComboBox6.Selected.Value, "High", 3, "Medium", 2, "Low", 1, 0)
},
score1 + score2 + score3 + score4 + score5 + score6
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" as a token of appreciation.

Was this reply helpful? Yes No