Answered

Delegation issues

(0) Share

Report

Posted on by WayneSS

Hi. I have a few delegation warnings in my Leave Request App. Any help would be much appreciated.

If(Weekday(ThisItem.Value) in [2, 3, 4, 5, 6] && !(ThisItem.Value in 'Bank Holidays'.BankHolidayDate),
Filter(
 WaSS_LeaveRequests,
 If( Request_Status="Accepted" || Request_Status="New",
 'Start Date' < ThisItem.NextDay And 'End Date' >= ThisItem.Value)
)
)

If(Weekday(ThisItem.Value) in [2, 3, 4, 5, 6] && !(ThisItem.Value in 'Bank Holidays'.BankHolidayDate),
Filter(
 WaSS_LeaveRequests,
 'Start Date' < ThisItem.NextDay And 'End Date' >= ThisItem.Value,
 'Employee Email'
)
)

Filter(
 WaSS_LeaveRequests,
 If(
 IsBlank(Filter_EmpName_1.Selected.Value),
 RequestStatus = (StatusChoice).New,
 Name = Filter_EmpName_1.Selected.Value && RequestStatus = (StatusChoice).New
 )
)

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @WayneSS ,
try this:
With({ weekday: Weekday(ThisItem.Value), isBankHoliday: !IsBlank(LookUp('Bank Holidays', BankHolidayDate = ThisItem.Value)) }, If(weekday >= 2 && weekday <= 6 && !isBankHoliday, Filter( WaSS_LeaveRequests, (Request_Status = "Accepted" || Request_Status = "New") && 'Start Date' < ThisItem.NextDay && 'End Date' >= ThisItem.Value && 'Employee Email' = ThisItem.EmployeeEmail ) ) )

If(IsBlank(Filter_EmpName_1.Selected.Value), Filter( WaSS_LeaveRequests, RequestStatus = (StatusChoice).New ), Filter( WaSS_LeaveRequests, Name = Filter_EmpName_1.Selected.Value && RequestStatus = (StatusChoice).New ) )
WayneSS 61 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you so much.

I'm improving the code so the calendar only shows the users team mates, rather than every employee in the company. I've got it working with the following code but unfortunately I've created another delegation warning:
With({ weekday: Weekday(ThisItem.Value), isBankHoliday: !IsBlank(LookUp('Bank Holidays', BankHolidayDate = ThisItem.Value)), userTeam: LookUp(StaffStructures, Staff_Name = User().FullName, TeamTxt), userSubTeam: LookUp(StaffStructures, Staff_Name = User().FullName, SubTeam) }, If(weekday >= 2 && weekday <= 6 && !isBankHoliday, Filter( WaSS_LeaveRequests, (Request_Status = "Accepted" || Request_Status = "New") && 'Start Date' < ThisItem.NextDay && 'End Date' >= ThisItem.Value, LookUp(StaffStructures, Staff_Name = Name).TeamTxt = userTeam && LookUp(StaffStructures, Staff_Name = Name).SubTeam = userSubTeam ) ) )