Answered

Get total inside canvas apps

(0) Share

Report

Posted on by NurNina

375

Hi, I have a sales header table which contains many sales order. each sales header has many sales line. Can I actually get the total line amount for each sales header inside a canvas apps?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,319 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NurNina ,
Just put a label for each with for numbers
Sum(YourGalleryName.AllItems, YourFieldName)
Replace with your gallery and field name
For the number of items in the gallery
CountRows(YourGalleryName.AllItems)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
NurNina 375 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz for the countrows function, Ive got an error saying that it expect a table value. Does that mean I need to replace my gallery with a table?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,319 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NurNina ,
No the syntax below should be as below - I just did a quick test on a gallery and (put your Gallery name where I have GalleryName below)
CountRows(GalleryName.AllItems)
Works fine

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No