Hi,
I think due to space in Full Name it is not filtering if I gave the last name to search. To overcome this I'm going to user StartWith and EndWith in the filter. However I think i will still have issues if searching with Middle name. Any idea how to overcome this.
I want to use delegable function in the filter so cant use "in" and my SharePoint list will go more than 2000.
Asia Doriea' Reynolds
Hi, 👋
Hi @indhaa ,
You have a couple of options that require some pre-planning of your data structure.
The main issue is that your filter is date-based and not Delegable. In my blog, I have a suggestion for a shadow date numeric field - this would make any query delegable.
You can also have a shadow ID field and make a big collection of the size required - then date queries are not subject to Delegation (they are "local").
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi Warren
Thanks for the help but i will try to manage with StartWith.
However need your input on another. This one not delegable and i will have issue. For the non delegable filter i used the sort to filter the latest since i wont have an issue if it counting the latest records.
However for this i need to count all the records that are expired. Any idea how to get the correct result. I think there might be in the future more than 2000 and if that is the case, it might yield incorrect result since the one i need might not be the latest. Hope I am clear with my requirement. Is there a way i can get the result using Powerautomate?
"Expired (" & CountRows(Filter(Sort(WiFiAccess,ID,Descending),(ExpiryDate<=Today() && RevokedDate>=DateAdd(Today(),-10,Days))||(ExpiryDate<=Today() && IsBlank(RevokedDate))))&")"
Expiry Date = is the Form expiry date
Revoked Date = access revoked due to request expires
Regards
Hi @indhaa ,
To search in the middle of a string, you need the in or Search filters, neither of which are Delegable. I have a blog on Delegation with some suggestions on large collections. Happy to elaborate further if any suit your model.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.