Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Search for Full Name

(0) ShareShare
ReportReport
Posted on by

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. 

  • asiareynolds751 Profile Picture
    asiareynolds751 4 on at
    Re: Search for Full Name

    Asia Doriea' Reynolds

     

  • asiareynolds751 Profile Picture
    asiareynolds751 4 on at
    Re: Search for Full Name

    Hi, 👋

     

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 145,434 on at
    Re: Search for Full Name

    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.

     

  • indhaa Profile Picture
    indhaa on at
    Re: Search for Full Name

    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

     

     

     

  • WarrenBelz Profile Picture
    WarrenBelz 145,434 on at
    Re: Search for Full Name

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard