How to Calculate value from 2 dropdown list and Assign values to another drop down

[Anonymous]

I was working on a project. And came across a problem I cant solve. I have 2 combo boxes inside an edit form you are allowed to choose one value from each combo box and then a third combo box contains 3 options which is decided by the multiplication of the combo boxA and combo box B .

I Tired (DataCardValue9.SelectedItems.Value)*(DataCardValue10.SelectedItems.Value) to just extract the value before the If statements but I get an error as expected number as Value returns table as a data type.

DataCardValue9

1

2

3

4

5

DataCardValue10

1

2

3

4

5

if lets say we selected 2 from DataCardValue9 and 3 from DataCardValue10 i need to get 6 so that i can start the if statement

[WarrenBelz]

Hi @Anonymous ,

Try this

Text(
   Value(DataCardValue9.SelectedItems.Value)*
   Value(DataCardValue10.SelectedItems.Value)
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[rubin_boer · Accepted solution]

hi @Anonymous 

Try (DataCardValue9.Selected.Value)*(DataCardValue10.Selected.Value) 

SelectedItems returns  a table so that will try to multiple two tables in the statement

(DataCardValue9.SelectedItems.Value)*(DataCardValue10.SelectedItems.Value) 

Hope it helps,

R

[WarrenBelz]

@Anonymous ,

Sort of a mixture between mine and @rubin_boer 's I think - I missed the SelectedItems, but I think you need Value() around them if those are Text choices.

[Anonymous]

This Worked thanks!

[Anonymous]

They weren't text values, Regardless thanks!