I have 3 sharepoint list
- Organization city
- organization( Lookup Field to Organization sharepoint List)
- Work Time
- 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)
Delegation warnings and full data from the source are not shown.
Looking for alternative ways/formulas without any delegation of API limit issues.