Unanswered

Drop Down List Selecting Value

(0) Share

Report

Posted on by Lance_Dunford

Hi Team

I am new to Power Apps and have been fumbling my way through building an App to calculate a cost based on Users using drop down boxes. I am using an Excel connector to tables. When a User selects an item from a list in a dropdown, it updates a List Box with a corresponding value. I then use more dropdowns until the User has selected all the criteria. At the end there are two or three items to calculate and show in a Text Input box. However, when the List Box updates with the new value, these are not automatically selected and therefore my calculation does see the new values.

Example: after selecting Dropdown1 the value is selected. ListBox 1 & 2 are populated from other dropdowns but are not selected.

Value(Dropdown1.SelectedText.Value)*Value(ListBox1.SelectedText.Value)+Value(ListBox2.SelectedText.Value)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

SoPatt Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I don't understand enough about where you are or where you are trying to go to come up with anything helpful. Show me more about your data. What are the items properties of your controls? Value property? For starters.

Was this reply helpful? Yes No
Lance_Dunford 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @sopatte

thanks for jumping in. Maybe I am going about this the wrong way

The Circuit Speed drop down changes the Speed Cost
The Speed in Mb is a multiplying factor and Per Mb Cost is fixed.
You can see that the Per Mb Cost is in blue showing that it is "Selected"
The Speed Cost is not in blue meaning it is not "Selected". This happens when the Circuit Speed is changed. This means that the Total Per Month does not factor it in to the calculation which in the case below should be 200 x 0.4 + 200. (Speed in Mb) x (Per Mb Cost) + (Speed Cost)

Was this reply helpful? Yes No
Lance_Dunford 4 on at

Like (0)

Report
Copy link

Link copied!

@sopatte The Speed Cost and Per Mb Cost are both List Boxes

Was this reply helpful? Yes No
SoPatt Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
I don't understand how which control is Selected has anything to do with your question. I also don't understand why Speed Cost and Per Mb Cost are List Boxes. I would make them labels. Then:
ddlCircuitSpeed.OnChange=Set(varSpeedCost,SelectedItem.SpeedCost) lblSpeedCost.Text=varSpeedCost lblPerMbCost.Text=varPerMbCost // set varPerMbCost in Screen.Visible or elsewhere ddlSpeedInMb.OnChange=Set(varSpeedInMb,SelectedItem.SpeedInMb) lblTotalPerMonth.Text=varSpeedInMb*varPerMbCost+varSpeedCost
Obviously I'm assuming things about the structure of your data in the Items property of your dropdowns.

Was this reply helpful? Yes No
SoPatt Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Why?

Was this reply helpful? Yes No