web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Grand total price calc...
Power Apps
Unanswered

Grand total price calculation in collection

(0) ShareShare
ReportReport
Posted on by

Hi guys,

I  have created a purchase request application where employees will enter purchase info 

the thing is I created a gallery view with collection name colMenu to for emp to enter info 

MarwaAlhajri_1-1719401570568.png

 

each time the click add line patch function will patch data to the collection 

Patch(
    colMenu,
    ThisItem,
    {
        'Description/Model No': TextInput1_1.Text,
        Currency: Dropdown2_1.SelectedText.Value,
        Quantity:Value(TextInput2_1.Text),
        'Total Price': TextInput3_2.Text,
        'Unit Price':Value(TextInput3_3.Text)
    }
);
now the Grand total calculation is based on the column total price 
create a label to view the Grand total with the formula 
"Grand Total:"& Sum(Gallery1_1.AllItems,'Total Price')
but now it will not show all the columns since the last column was not patched 
MarwaAlhajri_2-1719401710156.png

 

Categories:
I have the same question (0)
  • mmbr1606 Profile Picture
    14,560 Super User 2025 Season 2 on at
    Re: Grand total price calculation in collection

    hey @MarwaAlhajri 

     

    can u try this:

    Patch(
     colMenu,
     ThisItem,
     {
     'Description/Model No': TextInput1_1.Text,
     Currency: Dropdown2_1.SelectedText.Value,
     Quantity: Value(TextInput2_1.Text),
     'Unit Price': Value(TextInput3_3.Text),
     'Total Price': Value(TextInput2_1.Text) * Value(TextInput3_3.Text)
     }
    );
    

     

    and this in label:

    "Grand Total: " & Sum(Gallery1_1.AllItems, 'Total Price')
    

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • MarwaAlhajri Profile Picture
    on at
    Re: Grand total price calculation in collection

    Hi 

    I have already added the total price formula to the text input based on currency selected 

    MarwaAlhajri_0-1719403478983.png

    but what I want is to show the grand total of all rows 

    MarwaAlhajri_1-1719403552902.png

     

    as you can see the grand total only shows the first and second rows because the last row was not patched if I click add row then the grand total with show the third row 

  • MarwaAlhajri Profile Picture
    on at
    Re: Grand total price calculation in collection

    Can someone please help 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 836 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 231 Super User 2025 Season 2

Last 30 days Overall leaderboard