cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Antonio
Helper II
Helper II

Find Elements on Power app created by Sharepoint

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

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
SeanHenderson
Power Participant
Power Participant

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."

 

View solution in original post

2 REPLIES 2
SeanHenderson
Power Participant
Power Participant

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
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,928)