Hi @NurNina ,
Yes, your problem should be delegation problem.
Could you tell me:
1)whether your data is over 2000 records?
2)the data type of Verify field? the data in Verify field?
If your data is less then 2000 records, you just need to change the delegation limit to 2000.
Exactin is not delegate for CDS.
If Verify field could be compared with "=", you should set like this:
1)set the app's OnStart:
Set(var,Today())
2)set the gallery's Items:
Filter(Attendances, "No" = Verify,'Created On'=var)
If you really need to use "Exactin" to compare Verify field with "No", you could set like this:
1)set the app's OnStart:
ClearCollect(collection1,Filter(Attendances,ID<=1000));
ClearCollect(collection2,Filter(Attendances,ID>1000,ID<=2000));
ClearCollect(collection3,Filter(Attendances,ID>2000,ID<=3000));
....
//save entity data to multiple collections, ID is the unique field, you could replace with yours
2)filter data in collection one by one
ClearCollect(filtereddata,
Filter(collection1, "No" exactin Verify,IsToday('Created On')),
Filter(collection2,"No" exactin Verify,IsToday('Created On')),
Filter(collection3, "No" exactin Verify,IsToday('Created On')),
Filter(collection4, "No" exactin Verify,IsToday('Created On')),
....
)
3)set the gallery's Items:
filtereddata
ClearCollect function is not delegate neither. So you need to filter to get less then 2000 records to save to multiple collections.
Here are delegate functions for CDS for your reference:
https://docs.microsoft.com/en-us/connectors/commondataservice/
Best regards,
