Hi all, Can you help me on how to put a checkbox for a half day leave.
With(
{
// generate a one-column table of all dates between start date & end date
varDateRange: ForAll(
Sequence(ThisItem.'End Date' - ThisItem.StartDate + 1),
ThisItem.StartDate + Value - 1
)
},
If(
And(
IsBlank(ThisItem.StartDate),
IsBlank(ThisItem.'End Date')
),
// show nothing if any date pickers are blank
0,
// show only dates Monday to Saturday and exclude holidays
CountIf(
varDateRange,
And(
Weekday(Value) in [2, 3, 4, 5, 6, 7],
Not(Value in colHolidays.HolidayDates)
)
)
)
)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
203 | |
47 | |
43 | |
39 | |
36 |
User | Count |
---|---|
290 | |
82 | |
81 | |
79 | |
74 |