web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Grand total price calc...

Power Apps - Building Power Apps

Unanswered

Grand total price calculation in collection

Like (0) Share

Report

Report

Posted on 26 Jun 2024 11:40:26 by MarwaAlhajri

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

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

Categories:

Using Apps Using Formulas

All responses Img

All responses (3)

Answers Img

Answers (0)

MarwaAlhajri on 01 Jul 2024 at 12:18:16

Like (0)

Report

Re: Grand total price calculation in collection

Can someone please help
MarwaAlhajri on 26 Jun 2024 at 12:07:07

Like (0)

Report

Re: Grand total price calculation in collection

Hi
I have already added the total price formula to the text input based on currency selected
but what I want is to show the grand total of all rows

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
mmbr1606 13,494 Super User 2025 Season 2 on 26 Jun 2024 at 11:48:15

Like (0)

Report
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