Skip to main content

Notifications

Community site session details

Community site session details

Session Id : E/ebp/oimF/xdbyRVJAtPo
Power Apps - Building Power Apps
Answered

Multiple TextInput-variables

Like (0) ShareShare
ReportReport
Posted on 24 Feb 2022 11:35:48 by

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!

 

  • JR-BejeweledOne Profile Picture
    5,836 Super User 2025 Season 1 on 24 Feb 2022 at 11:55:02
    Re: Multiple TextInput-variables

    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)))
    
    )

     

  • Community Power Platform Member Profile Picture
    on 24 Feb 2022 at 11:54:01
    Re: Multiple TextInput-variables

    Omg thank you! don't know how i missed that!! 

  • JR-BejeweledOne Profile Picture
    5,836 Super User 2025 Season 1 on 24 Feb 2022 at 11:51:58
    Re: Multiple TextInput-variables

    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.

     

    MathFormula.png

     

    math.png

  • Verified answer
    Nogueira1306 Profile Picture
    7,390 Super User 2024 Season 1 on 24 Feb 2022 at 11:45:39
    Re: Multiple TextInput-variables

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 20

#2
BCBuizer Profile Picture

BCBuizer 10 Super User 2025 Season 1

#2
LC-26081402-0 Profile Picture

LC-26081402-0 10

Overall leaderboard