cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LindsayFairy
Level: Powered On

calculated field

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

1 ACCEPTED SOLUTION

Accepted Solutions
Mike8
Level 10

Re: calculated field

Hello,

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

View solution in original post

6 REPLIES 6
Mike8
Level 10

Re: calculated field

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

Community Support Team
Community Support Team

Re: calculated field

Hi @LindsayFairy

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

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: calculated field

Hi @LindsayFairy

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

LindsayFairy
Level: Powered On

Re: calculated field

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

 

Mike8
Level 10

Re: calculated field

Hello,

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

View solution in original post

Highlighted
LindsayFairy
Level: Powered On

Re: calculated field

Hi Mike8

 

The Sum formula worked!

 

Thank you very much for your assistance.

 

Kind regards

 

Lindsay

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 279 members 3,464 guests
Please welcome our newest community members: