Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Sum of the Gallery all items

Posted on 14 Dec 2024 07:26:30 by
Hi Every one 
 
i have button and gallery if the user clicks the button the new item will added to  gallery with empty fields in gallery then user will enter the data in that textboxes in those textboxes i have the txt_hrs , txt_amtphr and txt_ttl .txt_ttl will the view only which is set the formula i.e  
If(
    IsBlank(txt_hrs.Text),
    ThisItem.Ttl,
    (Value(txt_hrs.Text) * Value(txt_amtphr))
)  
Now i need the total of the txt_ttl all gallery items i have given the Text label outside of the gallery and the formula is given like this 
Sum(Glry_Part.AllItems,txt_ttl.Text) but im not getting the total value.
Button onselect property is having the collections the same collection i have given to gallery items 
Please give solution for getting the total value 
 
Thank you 
  • Suggested answer
    jpespena Profile Picture
    jpespena 294 on 14 Dec 2024 at 08:34:36
    Sum of the Gallery all items
    Hi,
     
    Try
    Sum(Glry_Part.AllItems,Value(txt_ttl.Text))

    If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,595

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,098

Leaderboard