Power Apps

Power Apps Search Filter Issue

(1) Share

Report

Posted on by AL-01100918-0

On this app, when I search for '3 R', the item [3 Rings] is displayed.

When I search for 'Rings', it does not find or display [3 Rings].

How can I edit the search box to filter any letters or words so I can see 3 Rings by only typing 'Rings'?

Format below:

SortByColumns(
    Filter(
        [@'Appendix D - Product and Service Approved & Prohibited List'],
        StartsWith(
            Title,
            TextSearchBox1.Text
        )
    ),
    "Title",
    If(
        SortDescending1,
        SortOrder.Descending,
        SortOrder.Ascending
    )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

markperrah 47 on at

Like
a
(1)

Report
Copy link

Link copied!
SortByColumns( Filter( [@'Appendix D - Product and Service Approved & Prohibited List'], TextSearchBox1.Text in Text(Title)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Was this reply helpful? Yes No
AL-01100918-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

markperrah - Thank you

Unfortunately, I am now getting unexpected behaviour - the '3 Rings' record has disappeared along with other records when searching:

Was this reply helpful? Yes No
Suggested answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

A Filter action with "in" won't return all results due to delegation. You can increase the delegation limit in Power Apps to handle more rows, but it won't solve the issue for datasets larger than 2,000 rows.

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

Was this reply helpful? Yes No
Suggested answer

Inogic 1,297 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Please try the below FX formula to search based on the text input.

SortByColumns(
    Filter(
        [@'Appendix D - Product and Service Approved & Prohibited List'],
        Search(@Datasource, TextSearchBox1.Text,Title)
    ),
    "Title",
    If(
        SortDescending1,
       SortOrder.Descending,
        SortOrder.Ascending
    )
)

Note: Replace the @Datasource with your entity

Hope this helps.

Thanks!
Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No