Search all Letters

(0) Share

Report

Posted on by MiniMax92

151

Hey,

I would like to be able to search for components in my cell of a table in my search field.

So for example: Now it's like this, I want to search for "keyboard MNB123" and enter "keyboard MNB" in the search field, then it shows me all the relevant keyboards. BUT, if I just search for MNB, it doesn't find anything.

The Product and the Product number are in the same cell in the table and with 13,000 rows it is not an option to put the model in a separate column.

That's why I need a deligable formula that searches everything in the cell and not just if the beginning is correct.

IMPORTANT! It must be deligable with over 2500 data sets. I've been using this deligable formula so far:

Filter(
    SharepoitList;
    StartsWith(
        Product;
        tbSearchInput_1.Text
    ) Or StartsWith(
        Manufacture;
        tbSearchInput_1.Text
    ) Or StartsWith(
        Size;
        tbSearchInput_1.Text
    ) 
)

Best regards.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report

Hey,

what you are trying to do is not possible with only power apps. The starts with function always searches for the Start.

There are two workArounds that come to my mind. One would be to create a table with all the different products. Example: {Value:"Keyboard"},{Value:"Mouse"}, {Vakue:"Screen"}

This is only possible if you don't have too many products but many different models of the same product.

then you woul dneed to collect in a for all loop all the Rows from your Datasource.

Another way that I would recomend is using a flow to do it.

Basically you send the string to Power automate. There the search is performed and then you create a table and send it Back to power apps. It should be quite fast but depends a bit on your datasource of course.

Was this reply helpful? Yes No
MiniMax92 151 on at

Like (0)

Report

Ok, the flow thing sounds good. Unfortunately I haven't worked with it yet.

Which elements do I need to add and how do I define them? The flow should access my search field and send the results to my gallery.

Was this reply helpful? Yes No
Suggested answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report

Here is a Link that explains how you can achieve this.

Let me know if you need further assistance.

If this Helped you solve your problem don't forget to mark it as solution.

Was this reply helpful? Yes No
MiniMax92 151 on at

Like (0)

Report
Ok thats look good.

I have one Problem with my formular in my Search field.

He tells me that "Run" is an unsupported function. Why?

ClearCollect( colbestInventory; ForAll( Table(ParseJSON(SPList.Run(tbSearchInput_1.Text).searchresults)); { ID: Value(Value.ID); Artikel: Value(Value.Artikel); Artikelbezeichnung: Text(Value.Artikelbezeichnung); Hersteller: Text(Value.Hersteller) } ) )

This formular is written in OnChange from my searchfield.

Was this reply helpful? Yes No
Suggested answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report

Sometimes there is a little bug. If the Flow is connected to the App already and you change something in the flow they lose connection.

You need to remove it once from the app and add it again then it should work fine.

If my Answer helped please mark it as a solution to your question.

Was this reply helpful? Yes No