Delegatio on functions with switch

(0) Share

Report

Posted on by JL-14111105-0

Hi I am creating an app that is used across multiple countries. The app uses Sharepoint as data source but the set of lists changes with the user region. Up to this moment I used something a bite brute-forcish like this (just as an example):

Count(Filter(Switch(varRegion, "Region1", List1, "Region2", List2, "Region3", List3, "Region4", List4), field1 = var1 && field2 = var2).ID)

What I noticed is that the Switch function with such an approach breaks down delegation on SP, so it works fine with lists with just over 1000 lines, and breaks down on list with over 4k lines. The functions work fine if I split them to not use Switch or If after Filter - however with that the code grows quite significantly with no apparent need. Any way to do it better? Can I somehow store datasource as variable within the tool (it's not environmental so env variable will not work I think)

Categories:

General

All responses (2)

Answers (0)

JL-14111105-0 4 on at

Like (0)

Report

Delegatio on functions with switch

Storing list in var has smilar issues - it breaks delegatio and in only able to pick up data from 1st 2000 rows
SaiRT14 1,755 on at

Like (0)

Report

Delegatio on functions with switch

Try the following:

Store List in a Variable:: Set(varDataSource, Switch(varRegion, "Region1", List1, "Region2", List2, ...))
Count(Filter(varDataSource, field1 = var1 && field2 = var2).ID)