Power Platform Community Forum Thread Details

Hello

We were looking at project ime hrs for our team snd found useful solutions here build as power apps template - https://community.powerplatform.com/galleries/gallery-posts/?postid=2c22f7a1-01d6-4e2e-a806-39207ebddbe2.

During demo video could get information about demo & installation, However would like to understand about overall time consilidation view e.g. Hrs per project, Hrs per reource or Hrs per activity type, where those can be avaialble for view?

Please advise

Categories:

General topics

HI @RA-07041050-0

The template is entry-only — no consolidated view ships with it out of the box. You'll need to add a reporting screen to the app itself.
Add a Reporting Screen in the Canvas App
Insert a new screen with a gallery or table control and use GroupBy + AddColumns to summarize the SharePoint data:

Hours by Project:

AddColumns(
    GroupBy(TimeEntries, "Project", "Entries"),
    "TotalHours", Sum(Entries, Hours)
)

Hours by Resource:

AddColumns(
    GroupBy(TimeEntries, "Person", "Entries"),
    "TotalHours", Sum(Entries, Hours)
)

Hours by Activity Type:

AddColumns(
    GroupBy(TimeEntries, "ActivityType", "Entries"),
    "TotalHours", Sum(Entries, Hours)
)

Drop each of these into a gallery's Items property with two labels per row — one for the group name, one for ThisItem.TotalHours. Add a date range filter on top using DatePicker controls and wrapping with Filter(TimeEntries, Date >= StartDate && Date <= EndDate, ...) before the GroupBy.

Adjust the above to best fit your needs / data.

Power BI is another option if your team already has the licenses, but the above keeps everything inside the app at no extra cost.

Hope that helps!