Answered

Avoid delegation warning for "in" operator

(0) Share

Report

Posted on by Calin_Mateut

Hello! I have a problem with delegation warning for "in" operator for the below formula. I have the formula on DisplayMode property of a submit button.

If(
 /* Your existing formula */
 IsBlank(
 First(Filter(
 SortByColumns( Calendar, "StartDate"),
 UserID = varEmployee.ID, Or( StartDate in workDayList.workDay, EndDate in workDayList.workDay)
 )) )
 ,
 DisplayMode.Edit, // Set to Edit if the formula is true
 DisplayMode.Disabled // Set to Disabled if the formula is false
)

How can I write the formula to have the same result. More precisely, that the StartDate and EndDate are within workDayList.workDay.

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Calin_Mateut,

Currently, the delegation issue caused by the in operator could not be solved.

Was this reply helpful? Yes No
Verified answer

Calin_Mateut 96 on at

Like
a
(0)

Report
Copy link

Link copied!
I managed to avoid delegation warning by replacing Calendar (SP list) with a collection that stores data from Calendar (SP list).

If( /* Your existing formula */ IsBlank( First(Filter( SortByColumns( colMonthGroup, "StartDate"), UserID = varEmployee.ID, Or( StartDate in workDayList.workDay, EndDate in workDayList.workDay) || UserID = varEmployee.ID && First(workDayList).workDay >= StartDate && Last(workDayList).workDay <= EndDate )) ) , DisplayMode.Edit, // Set to Edit if the formula is true DisplayMode.Disabled // Set to Disabled if the formula is false )

Was this reply helpful? Yes No