web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Calculate Average Base...

Power Apps

Answered

Calculate Average Based On Selection Of DropDownList

(0) Share

Report

Report

Posted on by NeohLooi

73

If(Dropdown2.Selected.Value = "Calculate two", (TextInput11.Text=Text(Average(Value(TextInput9.Text),Value(TextInput10.Text)))));

I want to calculate the average based on selection on dropdownlist, but it seem not working and I can't find out what's wrong with my code.

Is that any better solution for this? Thanks.

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@NeohLooi

Is TextInput11 the control where you want the Average to appear? If so, you don't need to reference it so remove that part of your formula ie

If( Dropdown2.Selected.Value = "Calculate two", Text( Average(...) ) )
Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @NeohLooi

The issue is that it is not possible to make assignments in the way that you're attempting. For example, we cannot use the syntax TextInput11.Text= to assign a value to the TextInput11 control.

If you were to set the text property of TextInput11 to the following formula, that should hopefully take you further.

If(Dropdown2.Selected.Value = "Calculate two", Text(Average(Value(TextInput9.Text), Value(TextInput10.Text) ) ) )
NeohLooi 73 on at

Like
a
(0)

Report
Copy link

Link copied!

I want it trigger on button , is that anyway to do it?
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NeohLooi

Set the OnSelect property of your button to:

Set(varAverage, If(Dropdown2.Selected.Value = "Calculate two", Text(Average(Value(TextInput9.Text), Value(TextInput10.Text) ) ) ) )

You can then set the Text property of your text input control to varAverage.

Join the conversation