How to make Summary data

(0) Share

Report

Posted on by answeriver

110

Hi all.

I have app, where users make orders. Data Source is SharePoint List.

I need to make on main screen summary table. I try to make simple sum by column share point list with quantity of products, bu it's not allowed. I thought it's simple, but i was wrong.

Do you have any examples for this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report

@answeriver

Please PROVIDE a sample of your data being used as an input for the summary. Then, show EXACTLY what the summary should look like.

The forums are most helpful when you ask a specific question.

---

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Rahber 1,935 on at

Like (0)

Report
Can you try this?
Sum(Filter('Name of the List','Status'="Completed"),'column to be counted')
So basically i am using filter to delgate the stuff to sharepoint to get me the required rows and then i have counted the columns. I am using a filter Status is completed and you can change it to your filter
My column type was Number.

Please mark the post as solution if it resolved your problem or if it helped you in anyway don't forget to up vote!

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (0)

Report
Hi @answeriver ,

Do you want to get sum of quantity based on product type?

If so, you need to firstly use GroupBy function to group rows based on product type, then use AddColumns and Sum function to add a column with the sum of quantity for each product type.

Could you show me your table's structure? fieldname, field data type?

I assume that you have a column named product(text type), a column named quantity(number type).

insert a data table, set its Items:

AddColumns( GroupBy(table,"product","products"), "sum of product", Sum(products,quantity) )

Best regards,

Was this reply helpful? Yes No