Answered

Search for Full Name

(0) Share

Report

Posted on by indhaa

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 154,496 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,496 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
asiareynolds751 4 on at

Like (0)

Report
Copy link

Link copied!

Hi, 👋

Was this reply helpful? Yes No
asiareynolds751 4 on at

Like (0)

Report
Copy link

Link copied!

Asia Doriea' Reynolds

Was this reply helpful? Yes No