cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
uhlemanna
Frequent Visitor

Filter a datatable sharepoint list

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
uhlemanna
Frequent Visitor

Finally I found my mistake in the filter statement.

 

And here is my Solution: 

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

 

View solution in original post

13 REPLIES 13
JR-BejeweledOne
Super User
Super User

It has to do with the language settings on your computer.   Some things are different in Power Apps if your separator is a comma instead of a dot.   The tutorials you look at are based on the language of the author.   In the U.S. there would be a comma after the data source.   In countries where the language separator is a comma, there would be this:  ; after the datasource.

 

You can read about it here:

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/global-apps



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
uhlemanna
Frequent Visitor

Thanks, but the site and my pc settings working with the same region. 

And it is not a big deal if , or ; but i still wondering why it telling me an error and I don't know what is wrong.

JR-BejeweledOne
Super User
Super User

Can you share a screenshot of your formula?

 



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
uhlemanna
Frequent Visitor

PA-Filter-Error.png

uhlemanna
Frequent Visitor

It is in german but it tells me that it expect a Text Value, ok and now?

JR-BejeweledOne
Super User
Super User

Is the Titel the normal SharePoint Title field (Single line of Text)?



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

yes it is

So to get a better idea of what you are doing, I need some additional information.

 

If I understand correctly you have a text box that you are using to filter your datasource and you want the form to display the item that is found when a title is entered into the text box?

 



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
uhlemanna
Frequent Visitor

you are right, this is what I like for this test. 

 

On the end, I like to filter all items from the 2nd list in the datalist by a reference of the current item.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

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