Find Elements on Power app created by Sharepoint

[Antonio]

Hello,

i've created a power app directly from my sharepoint online web site.

Unfortunately the Find Elements function is not working and i'm struggling with it.

The formula I'm using is not working : Filter('Fast Runner List',TextSearchBox1.Text,Text("Item_x0020_Number"))

The gallery is working well.

Can someone support me?

Thanks a lot for your help.

Regards

[SeanHenderson · Accepted solution]

Hi @Antonio 

Are you trying to create a search box that filters your gallery?

If that's the case, then set the items property of your gallery to:

If(!IsBlank(TextSearchBox1), Filter('Fast Runner List', Title = TextSearchBox1.Text), 'Fast Runner List')

In your case, substitute Title for whatever column you actually want to search on.

Unless I am misunderstanding your need.

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

[v-xida-msft]

Hi @Antonio ,

Could you please share a bit more about your scenario?

Do you want to filter your Gallery Items based on the "Item Number" value specified within the TextSearchBox?

Based on the formula you provided, I think there is something wrong with it. The second argument within the Filter function is required to provide a specific filter condition (e.g. ColumnName = "Specific value").

I have made a test on my side, please consider take a try with the following formula (set the Items property of Gallery to following😞

Filter(
        'Fast Runner List', 
        StartsWith(Text("Item_x0020_Number"), TextSearchBox1.Text)
)

or

Filter(
        'Fast Runner List',
        TextSearchBox1.Text in Text("Item_x0020_Number")
)

Please consider take a try with above solution, then check if the issue is solved.

Best regards,