Power Apps - Building 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:

Using Apps Using Formulas

All responses (4)

Answers (0)

Suggested answer

Inogic 1,043 Super User 2025 Season 1 on at

Like (0)

Report

Power Apps Search Filter Issue

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/
Suggested answer

SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Power Apps Search Filter Issue

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
AL-01100918-0 4 on at

Like (0)

Report

Power Apps Search Filter Issue

markperrah - Thank you

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

Like (1)

Report
Power Apps Search Filter Issue

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