web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Answered

calculated field

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi

 

I am trying to calcalate the value of several textinput boxes which are contained within a gallery that is on another screen to where I want the figure to show.  I have been trying to get a formula to work for days but to no avail.  I shall be most grateful if anyone can provide any assistance as at the moment, I can only get the most recent entry to pull through onto my screen, not all of the textinput values.

 

Thanking you in advance.

 

Lindsay

Categories:
I have the same question (0)
  • Mike8 Profile Picture
    1,330 on at

    Hello,

    Are you trying to have something like this?
    1    2  -->  3
    2    5  -->  7
    Or something like this?
    1    2 
    2___5 
    3     7
    If you provide some more information we can make it work

  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous

    Could you please share a bit more about your scenario?

    How do you calculate the value of several TextInput boxes? Could you please share a bit more about the formula?

    If you want to display the calculated result within another screen, I think the Global variable could achieve your needs. You could consider take a try to store the calculated result into a global variable (using Set() function), then display the variable value within your another screen.

    Please take a try with the following formula:

    Set(Variable1, CalculatedResult1);
    Set(Variable2, CalculatedResult2);
    ...

    then you could display the calculated result via the Variable1, Variable2, ... within your another screen.

    More details about the Set function, please check the following article:

    Set function

    Note: You could not use UpdateContext() function to initialize your variable, context variables are scoped to a screen, which means that you can't build a formula that refers to a context variable on another screen.

     

    Best regards,

    Kris

  • timl Profile Picture
    36,785 Super User 2026 Season 1 on at

    Hi @Anonymous

    I think that @Mike8 raises an excellent question, and the answer to that would be of great help to us.
    What Mike is asking is - do you want to calculate a value from textinput boxes within a *single* record? Or do you want to perform some sort of an aggregate calculation? (in other words, do you want to calculate a value from *multiple*  records in your gallery?)

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi 

     

    Thank you both for your prompt replies. 

     

    I have attached screenshots to hopefully help clarify what I am trying to achieve.

     

    Many thanks

     

    Lindsay

     

  • Verified answer
    Mike8 Profile Picture
    1,330 on at

    Hello,

    You can try this..
    TextInput1_4.Default =  Sum(Gallery1.AllItems,TextInput2_1.Text)

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Mike8

     

    The Sum formula worked!

     

    Thank you very much for your assistance.

     

    Kind regards

     

    Lindsay

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard