Looking for alternative formula without delegation warning

[pcakhilnadh]

Datasource structure

I have 3 sharepoint list

1. Organization
   1. Id
   2. organization_name
   3. Organization city
2. Employee
   1. Id
   2. employee_name
   3. organization( Lookup Field to Organization sharepoint List)
3. Work Time
   1. Id
   2. UserID(Lookup to Employee Sharepoint List)

The formula applied on gallery items is as follows:-

Filter(WorkTime,UserID.Id in Filter(Employee, organization.Value = ComboBox1.Selected.organization_name).ID )

Alternatively without "in"

Filter(AddColumns(WorkTime, "org", First(Filter(Employee, organization.Value =ComboBox1.Selected.organization_name).'organization:organization_name')), org.'organization:organization_name'.Value = ComboBox1.Selected.organization_name)

Issue:

Delegation warnings and full data from the source are not shown. 

Looking for alternative ways/formulas without any delegation of API limit issues.

References

1. https://powerusers.microsoft.com/t5/Building-Power-Apps/Powerapp-filter-lookup-of-a-another-lookup-f...

2.https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations#request-limits-...

3. https://powerusers.microsoft.com/t5/Building-Power-Apps/Issue-with-quot-in-quot-operator-inside-quot...

[v-xiaochen-msft · Accepted solution]

Hi @pcakhilnadh ,

You could use flow to get all Items (up tp 100000) and return them to canvas.

Turn on this setting.

At this point, you can add the returned data to the collection。

Best Regards,

Wearsky