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

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (52,906)