Filter a datatable sharepoint list

[uhlemanna]

Hi, I just start working with PowerApps and I try to start to create a custom listform (SharePOint Online).

I insert a secound connection to an other SPO list and put it as a datatable to the form, good so far 🙂

But I tried to follow some tutorials to implement a filter and stock on the formula.

in the most tutorials there is a "," after the source, but the system tells me it shoud be a ";", I mean I don't care I can handle it but my simple formula does not work so this is my formula:

Filter(testlist; Titel = SearchTextBox.Text) 

the debug tells me an error in the formula but not where 😞

can anybody help?

Thanks 

Alex

[JR-BejeweledOne]

So this is actually more complicated than I realized.    The easiest way to handle this would be to have a gallery (you can hide it so it's not visible on the screen).  

Gallery Settings:

Items:  Filter(Datasource, Titel = Search.Text)

Visible: false

Form Settings:

DataSource:  Same datasource as Gallery

Item:  GalleryX.Selected

This will work, but your form will have a message 'No Item to Display' when the Text Input is blank.  You could use the visible property of the form to only be visible if our text input isn't blank

[uhlemanna]

Hi 

I tried to follow your steps but I 've got lost again.

I added a gallery connected to the list but where can I set the Item focus to Gallery1.Selected?

And btw, it would not be so bad to see there is no reference, that would be even helpful for the process.

[JR-BejeweledOne]

You set the Item focus in the Items property of the form that you are using to display the information.

[uhlemanna · Accepted solution]

Finally I found my mistake in the filter statement.

And here is my Solution: 

Filter(TestList; PlainText('RefField'.Value) = PlainText(SearchBox.Text))