Skip to main content

Notifications

Display employees work hours as 8 or zero according to the day they work

 Profile Picture Posted by Community member

Hi all, 

I want my Power Apps to display my employee hours as 8 or zero accordingly under the days they work. I have a timesheet that track the days employees work in Sharepoint list. I am using a nested gallery. The function I use for the parent gallery is:

With(
{
TimesheetValue: Sort(
AddColumns(
GroupBy(
Filter(
varTimesheetData,
Month(Date) = Month(varCurrentDate)
),
"Title",
"StaffGP"
),
"EmployeeID",
First(StaffGP.EmployeeID)
),
Title,
SortOrder.Ascending
)
},
ForAll(
Sequence(CountRows(TimesheetValue)),
Patch(
Last(
FirstN(
TimesheetValue,
Value
)
),
{RowNumber: Value}
)
)
)

//////////////////////////////////////////////////

For the nested gallery, I am using:

ForAll(Sequence(31),If(Day(Last(FirstN(ThisItem.StaffGP,Value)).Date)=Value,"8","0"))

Because the employees do not work everyday, I am having trouble displaying "8" or "0" accurately underneath the date. For example, employees do not work on Sundays but they work on Mondays, but the App is showing "0" for Mondays. Can anyone help? Thanks.

 

Categories:

Comments