Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Global Variables = No Value

Hello @ eka24  @

I followed your instructions to set a global variable on a calculated field:

Set(MyCalFigure,1Sum(GalleryHours.AllItems, HOURS)) in a button on screen 1

l added a label and put the Variable on the Text property: MyCalFigure1.

I did the same for 2 other screens which are records from the Main gallery MyCalFigure2 and MyCalFigure3 but nothing is showing in the global variables collection. Each variable shows "No Value" in the variables collection info.

I would like to add the total of these 3 variables together on the main gallery screen MyCalFigure1+MyCalFigure2+MyCalFigure3 but this doesn't work.

It may be worth noting that the Hours used in the calculation are in 'GalleryHours' not the Main Gallery - does this matter?

What am I doing wrong???

Thanks in advance


Hi @Englishweb ,

You already have a couple of very capable helpers in @eka24 and @v-siky-msft , but I will throw in how I would design this myself - bear in mind there are many different solutions to any problem.

I would make a collection of the filtered result you want and then Patch the sum total of this back to list one.

Again my preference only, but you also can do things in stages with Collections and Variables rather than try to make one huge complex formula to do it.

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (46,063)