web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to show the name o...

Power Apps

Answered

How to show the name only once if I have many same name

(0) Share

Report

Report

Posted on by kit1128

109

Hi guys,

I've some technical problem as shown. The picture 1 show the project and working hours which filter with usermail in gallery.

But how can show the name only once and count the working hours of the same project like picture 2?🤔 未命名.png

未命名1.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@kit1128

Can you please try using this code to SUM the working hours by project?

DropColumns( AddColumns( GroupBy(Filter(ETimeSheetMain, Title = UserMail),"Project","GroupedProjects"), "Sum of Value",Sum(GroupedProjects,WorkingHours) ), "GroupedProjects" )

---
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
kit1128 109 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @mdevaney ,
there are some error as shown

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@kit1128
It might be called ThisItem.Value or ThisItem.Result instead now. If neither works type ThisItem. and let me know what autocomplete suggests.

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

Was this reply helpful? Yes No
kit1128 109 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney
It works! Thanks a lot! Have a nice day!😁

Was this reply helpful? Yes No

Join the conversation