nested gallery sum for each records

(0) Share

Report

Posted on by venka91

1,119

Hi there,

my gallery looks like below.

for the dates and two text boxes i used one more gallery within my main gallery.

Now i want to sum the text boxes in gallery B and show the result gallery A for each records. Kindly assist.

my formula in gallery A

GroupBy(Filter(SP_Milk,smon = dd_milkreportmonth.Selected.MonthName, syear= dd_milkreportyear.Selected.Result),"cow_name","cowGroup")

my formula in gallery B

AddColumns(ThisItem.cowGroup,"SumofMorning",Sum(morn_milk))

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

MithaliGupta 242 on at

Like
a
(0)

Report
Copy link

Link copied!

@venka91 ; I would like to know if u are using Sharepoint to store the details ; if so; u can just use sum in Gallery B and Store the details and if u can elaborate more on ur issue will assist better

Was this reply helpful? Yes No
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

i am using sharepoint.

Gallery A shows only the Cow names

Gallery B shows its respective milking details for each day. each record here has two values morning milkyield and evening milkingyiled.

Example

for Animal_A in Gallery A, i would like to sum the values that is fetched in gallery B.

Was this reply helpful? Yes No
MithaliGupta 242 on at

Like
a
(1)

Report
Copy link

Link copied!

@venka91 I think you can use SharePoint calculated column to help you best in this...Like Gallery B specific date morning count + evening Count = Total Count;

Because specifically gallery will assist to display details calculations can be done better at the back end for accuracy;

Hope this Answer's your concern;
Please do accept this answer as solution

Was this reply helpful? Yes No
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

hi

my purpose is entirely different, and this way our customer want it to be designed. Please provide if you have idea on how do it in powerapps.

Was this reply helpful? Yes No
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

@cha_cha @WarrenBelz , anyone pls help.

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!
@venka91

In GalleryA, you should be able to add a label and use this syntax to work out the sum.

Sum(GalleryB.AllItems, SumofMorning) + Sum(GalleryB.AllItems, SumofEvening)

Was this reply helpful? Yes No
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there,

is it possible to get a day wise sum ?

example in calendar day 1st, 2nd, 3rd etc ?

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @venka91

If you want to display a sum by day outside of the gallery, I suggest that you duplicate what you've done already but remove the call to GroupBy. That would effectively give you a grand total.

Was this reply helpful? Yes No
venka91 1,119 on at

Like
a
(1)

Report
Copy link

Link copied!

hi @timl

Thanks. I managed to do this by converting this gallery into Horizontal gallery and i was successfully able to generate the grand total and also able to show the milk yield date wise and this looks neatly.

the only place where i failed, i am not able to import this gallery as PDF, as PDF function does not support nested gallery.

i am also do not have much expertise in writing Power Automate flow, as even i would like to convert the gallery format as CSV table, this has records within records, so i am not sure how can i generate report in either csv / html or pdf.

Was this reply helpful? Yes No
faruk1 110 on at

Like
a
(0)

Report
Copy link

Link copied!

Can i show this value outside of gallery, in forms datacard, i am getting error with this, please suggest

Was this reply helpful? Yes No