LookUp inside filter function is giving delegation error

(0) Share

Report

Posted on by SAGOS_12

Hello all,

I am trying to apply filters on the gallery. One such filter is to get tasks updated between starttime and endtime.

Filter(
	Tasks As rtTask,
	rtTask.Tasktype = "MainTask",
	rtTask.TaskHours <= 0,
	LookUp(subTaskTable,TaskId.TaskId = rtTask.TaskId).updateTime >= varshiftTime && 
 LookUp(subTaskTable,TaskId.TaskId = rtTask.TaskId).updateTime <= varshiftTimeEnd,
 rtTask.TaskName in systemTaskColl
)

The lookup inside filter function is giving me delegation warning. Is there any alternate approach to make this work? Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

VaidasG 469 on at

Like (0)

Report
Hi @SAGOS_12,

try moving your lookups outside of the filter and set it's values as variables:
Set(var1, LookUp(subTaskTable,TaskId.TaskId = rtTask.TaskId).updateTime), Set(var2, LookUp(subTaskTable,TaskId.TaskId = rtTask.TaskId).updateTime)
then use these values for your filtering

Regards
VaidasG

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
SAGOS_12 14 on at

Like (0)

Report
Thanks for the response. Not sure how this gonna help, let me elaborate.
Main Task table:
TaskID TaskName TaskType TaskHours
Task01 test MainTask 5
Task02 test22 MainTask 10
Sub Task Table: It has lookup column to the main task table.
SubTaskID TaskID UpdateTime
sub01 Task01 5/10/2023 10:00 AM
sub02 Task02 3/25/2023 1:00 AM
Now on Items property on Gallery to show main Task table:

Filter( Tasks As rtTask, rtTask.Tasktype = "MainTask", rtTask.TaskHours <= 0, FilterShift.Value = false Or (LookUp(subTaskTable,TaskId.TaskId = rtTask.TaskId).updateTime >= varshiftTime && LookUp(subTaskTable,TaskId.TaskId = rtTask.TaskId).updateTime <= varshiftTimeEnd), rtTask.TaskName in systemTaskColl )

When a toggle (FilterShift) is selected:
varShiftTime is set to 5/09/2023 11 AM and varShiftTimeEnd is set to 5/10/2023 11 AM. Since 'sub01' falls under this time,
Gallery should show only one item - Task01.

But the above filter formula is giving delegation due to lookup function. Any idea how to correct this?

Was this reply helpful? Yes No
SAGOS_12 14 on at

Like (0)

Report

@WarrenBelz
Hi, could you please help me on this one.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
Hi @SAGOS_12 ,

You are not going to get that completely Delegable if you are referring to a field in the Data Source being queried. Also you did not state your data source, but if it is SharePoint, you also have an in filter there which is not Delegable - this is the best I believe you can do (which may be adequate)

With( { wData: Filter( Tasks, Tasktype = "MainTask" && TaskHours <= 0 ) }, Filter( AddColumns( wData, "UDTime" LookUp( subTaskTable as aSub, aSub.TaskId = TaskId ).updateTime ), UDTime >= varshiftTime && UDTime <= varshiftTimeEnd && TaskName in systemTaskColl ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
SAGOS_12 14 on at

Like (0)

Report

Thank you @WarrenBelz . It helped me to look at writing formula in different perspective. Appreciate it.

Was this reply helpful? Yes No