web

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

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

Power Apps - Building Power Apps

Unanswered

Grand total price calculation in collection

(0) Share

Report

Report

Posted on 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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

mmbr1606 14,282 Super User 2025 Season 2 on at

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

Was this reply helpful? Yes No
MarwaAlhajri on at

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

Was this reply helpful? Yes No
MarwaAlhajri on at

Like (0)

Report

Re: Grand total price calculation in collection

Can someone please help

Was this reply helpful? Yes No

Join the conversation