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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,845)