web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Get total value from a...

Power Apps

Answered

Get total value from a collection

(0) Share

Report

Report

Posted on by Aysan

271

Hi,

I have a collection in the power app which I created based on Groupby() which looks like following

ClearCollect(coltest,AddColumns('TimeSheet App_TimeEntries',"EMP",Employee.DisplayName));

ClearCollect(colc,GroupBy(coltest,"EMP","Week_x0020_Start","DATA"));

in the DATA table, I have a column called Total

I am wondering what is the best way to create a gallery which shows "EMP", "WeekStart" and "Sum(Total)" from the DATA table for each employee

Thank you so much!

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Aysan ,

Do you want to display the total value of the Total column in each DATA sub-Table in Gallery?
Please try this:
Create a Gallery and insert a Label control.
Set the Text of the Label:
Sum(ThisItem.DATA,Total)

Hope this helps you!
-------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li
Aysan 271 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much @v-mengmli-msft , Would you please let me know how can I create a new collection using the sum(thisitem.DATA,Total) as a column rather than a table?
I would like to have a collection such as the following.
Thank you !!
Aysan 271 on at

Like
a
(0)

Report
Copy link

Link copied!
To anyone who might look for a solution to merge and create a new collection, I ended up using the following code:
ClearCollect(coltest,AddColumns('TimeSheet App_TimeEntries',"EMP",Employee.DisplayName)); ClearCollect(colc,GroupBy(coltest,"EMP","Week_x0020_Start","DATA")); ClearCollect(colcoll, ForAll(Sequence(CountRows(colc)), { _hours:Sum(Index(colc,Value).DATA,Total), _EMP:Index(colc,Value).EMP, _Week:Index(colc,Value).Week_x0020_Start, _Approval:First(Index(colc,Value).DATA).Status.Value }))

Join the conversation