We use a clearcollect to retrieve the employees from Sharepoint Lists (Collection: Employees) and then we are using another clearcollect that looks for the courses these employees took.
We get the courses like this:
ClearCollect(Courses,Filter(Courses_Employees, ID_Employee in Employees.ID))
So we are looking at the Courses_Employees table, trying to filter only the Courses that the employees we searched for took, which is why we use the in operator. But this is throwing a delegation error for the "in" operator when working with large operators, we would like to get them immediately based on the employees we searched rather than using buttons to retrieve that employee specific courses.
How can we overcome this limitation? We can't use premium connectors.