Creating a search filter in PowerApps

[Anonymous]

So I was following this video Applying filter in PowerApps DataTable - YouTube and used the same formula as mentioned.

However, I'm still getting errors and not sure why.

DataTable1 is my data table that I'm working with

Title_Column1 is the column I'm trying to search in

TextInput1 is my textinput box I'm using to search

Somehow though, this isn't working. The errors are very vague as well, just says invalid argument types and invalid argument.

[poweractivate]

@Anonymous 

What happens if you just put this to test for the Items property of the Data Table or Gallery control?

'30M Report'

If the above shows nothing, this is not the right data source then, it's a different data source with different columns.

Adjust the name of the data source, then try it. Then if it works, try to revise the formulas with this adjusted data source name.

See if it works @Anonymous 

[poweractivate]

@Anonymous 

Also try this below instead in case it helps:

Change the OnSelect property of the Button control to

Set(myVar01,ForAll('30M Report' As myRecord, TextInput1.Text in myRecord.Title));

In the Items property of the Gallery or Data Table control put this:

If(!IsEmpty(myVar01),myVar01,'30M Report')

Try it with IsEmpty instead of IsBlank - does it work now?

[Anonymous]

loads back up 

[poweractivate]

@Anonymous 

Try IsEmpty instead of IsBlank see if it works as below:

For the OnSelect property of the Button control, use this formula:

Set(myVar01,ForAll('30M Report' As myRecord, TextInput1.Text in myRecord.Title));

In the Items property of the Gallery or Data Table control, use this formula:

If(!IsEmpty(myVar01),myVar01,'30M Report')

See if it works @Anonymous 

[Anonymous]

No luck, still not displaying anything. Do I need anything set for my text input as far as formulas go?

[poweractivate]

If you don't want to press the Search button each time, then yes:

OnChange of Button

Set(myVar01,ForAll('30M Report' As myRecord, TextInput1.Text in myRecord.Title));

(you must click out of the Text Input after inputting the information, for it to take effect)

if not, you should not need it if you always click the Search button.

[Anonymous]

No luck, yea the typing and auto searching is better. I'll ditch the button. What formula do you recommend trying for my text input?

[poweractivate]

@Anonymous 

Does it show anything when you type in a matching record Title?

It might not work in the beginning to show all the records for this reason:

You might need to set the variable to empty table in the beginning, try this OnVisible of Screen1 (and then use a Blank screen and toggle back and forth between it to fire this in the Editor)

OnVisible of the Screen

Set(myVar01,[])

See if it helps @Anonymous 

[Anonymous]

no luck in preview. Tried typing, clicking out, search, nothing. Tried just typing the letter 'D' to show all, no luck.

[Anonymous]

I was using sharepoint as a data table and now trying excel, sadly no luck either