cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Search function won't display items

My app is connected to Excel file hosted on OneDrive. 

 

I have a basic text input to act as a search bar. 

 

My Gallary.Items is set to a basic search formula:

 

Search(Table2Data,SearchBar.Text,"MDN")

But the gallary does not show any items when I launch the app unless I type something into the search box and then delete it. 

 

Am I missing something here?

1 ACCEPTED SOLUTION

Accepted Solutions
mx
Advocate III
Advocate III

I solved this problem as shown below:

 

2017-10-19_13-59.png

DatabaseMX ('mx')
Microsoft Access MVP

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

This is a known bug that happens with Search()

 

To solve this add this to your code:

 

If(
    IsBlank(SearchBar.Text),
    Table2Data,
    Search(
        Table2Data,
        SearchBar.Text,
        "MDN"
    )
)

 

mx
Advocate III
Advocate III

I solved this problem as shown below:

 

2017-10-19_13-59.png

DatabaseMX ('mx')
Microsoft Access MVP

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (28,353)