Answered

Result is visible in formula bar not showing in the screen - Sum of Gallery Item

(0) Share

Report

Posted on by Vinishr

I was using the below formula to get the Sum of an Item from Gallery, which was working perfect. But now there is a problem.
The Result is not appearing in the screen/Label. However, I can see the result in the formula bar and when I edit the formula bar the result appears in the screen but still does not perform calculation when related data is changed.

Text(Sum(OEM_GalleryList.AllItems,Month1),"[$-en-US]#,##0")

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Vinishr

What is Month1? If that is a label or other control, you should reference the property that has the value.

If it is a column of data in your gallery then your formula appears fine.

It could be a condition of "studio flake" - this happens sometimes where the controls on the screen do not perform as expected. Sometimes a Ctrl-X and Ctrl-Z on the control will resolve it. Sometimes as far as to do the same with the entire Gallery.

I hope this is helpful for you.

Was this reply helpful? Yes No
Vinishr 14 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

Month1 is column of data in gallery (OEM_GalleryList).
This issue is with only few Labels from last two days and the result is visible on the label only after editing the formula in formula bar, and is not interactive when data changes in Month1 column.

Ctrl-Z and Ctrl-Y is not helping. Your guidance in fixing this will be appreciated, thanks.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Vinishr

This seems a bit strange.

Out of curiosity, now that a couple days have gone by, does the problem still persist or has it magically cleared up?

Was this reply helpful? Yes No
Vinishr 14 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

It was working fine yesterday after I changed the formulas to below
Text(Sum(OEM_GalleryList.AllItems,Value(Month1.Text)),"[$-en-US]#,##0")

But now again its not working 😞 I am trying to find out a fix and there is No error message either.
The issue is with Sum of Gallery Items.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Vinishr

So you have changed your formula to include Month1.Text - I had specifically asked if Month1 was a column for that purpose.

Is Month1 a Label/TextInput control, a data column or Both? If both, you might consider renaming the control to a dissimilar name.

Was this reply helpful? Yes No
Vinishr 14 on at

Like (0)

Report
Copy link

Link copied!

@ RandyHayes

I had to use .Text for Month1 since I used Value formula.

Month1 is a Label Control not associated to any data column. It is a calculated filed in gallery with formula Text(ThisItem.ActualTarget*GTS_MonthShare_Perc_M1.Text,"[$-en-US]#,##0")

Now I just realized that the problem is only in the Powerapp Studio. After I published the app I don't see any bug when I run the published app via Web Link. But the issue still exists when I edit/Preview in the Studio.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Vinishr

That makes more sense. You had mentioned it as a column previously, so I assumed it was data.

Yes, you should always reference the property that has the value you want to use - in this case .Text

You should change the formula on your Month1 Label control Text property to the following:

Text(ThisItem.ActualTarget * Value(GTS_MonthShare_Perc_M1.Text),"[$-en-US]#,##0")

Automatic conversions from text to numeric and the other way around have strange results in the player and editor.

If that doesn't clear it up, then observe your label that you're having problems with and press the Alt key on your keyboard in the designer studio. See if it appears when you do that.

Was this reply helpful? Yes No
Vinishr 14 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

sorry for that, I have both data column and calculated label items in the gallery so got confused.

I changed the Text property to below still not getting the result
Text(ThisItem.ActualTarget * Value(GTS_MonthShare_Perc_M1.Text),"[$-en-US]#,##0")

Also tried Alt key and still has no difference. Only in the Published app things work perfectly. Both Edit/Preview in studio does not show the result.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Vinishr

What's going on with the GTS_MonthShare_Perc_M1 text property? Perhaps there is some clue there.

Was this reply helpful? Yes No
Vinishr 14 on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes

'GTS_MonthShare_Perc_M1' text property have below formula.

Text(Value(LookUp(Global_MonthlyTarget,MonthNbr=1&&FY_Qtr=FYQtr_Dropdown1.Selected.Result,GP)/GTS_GPQtr_Value.Text*100),"[$-en-US]0.00000000%")

You are right about Value & Text property. I had updated all the related formulas with Value format and it works now. Thanks for the support.

Was this reply helpful? Yes No