Unanswered

Use formulas to perform calculations

(0) Share

Report

Posted on by agneseb

Hi, I am very new to PowerApps and I am trying to understand how it works.

I am therefore tying to implement the example described here Use formulas to perform calculations - Learn | Microsoft Docs but I have two issues:

1) I don't find "TextInput" therefore I used "TextBox" (I hope is the same)

2) The sum gives me an error and doesn't work (see attach

Can you please help me?

Categories:

Building Power Apps

Untitled.png

I have the same question (0)

All responses (3)

Answers (2)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Hi @agneseb ,

1. Yes, as I saw in your picture you choose the right controls. For a better user experience, select your TextBox2/TextBox3 and set the format to number:

2. You need to refer to the Text property of the TextBox2 and TextBox3 controls and because this values are store as text you need to convert it to number. So the formula you looking for is:

Text(Value(TextBox2.Text)*Value(TextBox3.Text),"@#,###0.00")

Hope it helps !

Was this reply helpful? Yes No
Verified answer

agneseb 23 on at

Like (0)

Report

Hi and thanks for your answer. Unfortunately it doesn't work
1. I can't find the Format properties, all I see in the properties is this
I also tried to looked at the advanced but there is nothing.
2. I tied also to put this formula, but I get still errors

I guess the issue is on point 1 or on the fact that I use a TextBox instead of an InputBox, but InputBox is not available in my inputs
😫

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (1)

Report

hi @agneseb

The Sum function either sum the values in a column or list of numbers. looks like you are mixing the two a bit.

In your example Value(Textbox1.Text) * Value(Textbox2.text) will provide an answer the function will look like:

Text(Sum(Value(Textbox1.Text) * Value(Textbox2.text),"[$-en-US]#,###")

Text(Value(Textbox1.Text) * Value(Textbox2.text),"[$-en-US]#,###") - notice no sum as per @GABI1 reply

Hope this helps

Was this reply helpful? Yes No