Hi @KUNGFUPANDA559 ,
What is your data source? Can you share the delegation warning details?
How many rows does data source have?
I have made a test (based on Sharepoint, more than 500 items), and don’t have the delegation issue you mentioned.
As the image shown, the 512th record can be looked up.
By the way, the lookup function , the operator ‘=’, and the data source are all the factors that can’t be delegated.
So please post your data source and delegation warning details to make an accurate judgment.
If you want to overcome the 500 items limitation, you can refer to following:
- Increase the total limit items from 500 to 2000(Max) if the amount of record is under 2000.
Click file (top left corner) > App settings > Advanced settings > set value for non-delegable queries.
- If the amount of record is more than 2000, create collection to store the data, and use collection in your formula instead of the current data source.
- Set the OnStart property of the App control as below:
Note: assume the amount of datasource is 6000, and have the primary identify type column “ID”.
Concurrent(
ClearCollect(VarCollection1, Filter(dataSourceRead, ID >= 1 && ID <= 2000)),
ClearCollect(VarCollection2, Filter(dataSourceRead, ID >= 2001 && ID <= 4000)),
ClearCollect(VarCollection 3, Filter(dataSourceRead , ID >= 4001 && ID <= 6000)),
);
ClearCollect( VarCollection, VarCollection 1, VarCollection 2, VarCollection 3)
Tips: If you don’t know the amount of datasource, you can check this:
UpdateContext({firstrecord: First(datasource)});
UpdateContext({lastrecord: First(Sort(datasource, ID, Descending))});
Amount= lastrecord.ID - firstrecord.ID- Modify your formula as below:
If(Len(tSS_2.Text)=9,Set(itemRecord,LookUp(VarCollection,UNIQUE_ID=tSS_2.Text)), Set(itemRecord, LookUp(VarCollection ,BADGE=Value(tSS_2.Text))))
Please have a try with above workaround, and check if the issue is solved.
Best regards,
Sik
