Answered

Multiple TextInput-variables

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey! I'm trying to use 2 input boxes to get a button to calculate and display my result in a third box. It has worked so far when I only have one input box, but when I add the other it says "Edit your formula so that it evaluates to a text or a number at this point in the formula".

The boxes are coded exactly the same so they are identical.

This is the formula for my button that displays the error message above:

If(Dropdown1_6.Selected.Value="B" And Dropdown1_15.Selected.Value="K",
Set(varResult, Value(TextInput1_6.Text)*2/(8*Value(TextInput1_7)))

)

When I take out my second TextInput (1_7) it runs just fine, no idea what the issue could be so any advice would be super helpful!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If(Dropdown1_6.Selected.Value="B" And Dropdown1_15.Selected.Value="K",
Set(varResult, Value(TextInput1_6.Text)*2/(8*Value(TextInput1_7.Text)))
)

A ".Text" was missing there

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

For troubleshooting purposes, just work on the math function. Once you have that working then add in the If portion with one at a time. I am not sure that your issue is the math. Can you provide a screenshot of that error?

I tried your formula and it works fine with no errors.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Omg thank you! don't know how i missed that!!
JR-BejeweledOne 5,836 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Here is your issue. Add the .Text to the second Text box part. TextInput1_7.text.

If(Dropdown1_6.Selected.Value="B" And Dropdown1_15.Selected.Value="K", Set(varResult, Value(TextInput1_6.Text)*2/(8*Value(TextInput1_7.Text))) )