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?
Solved! Go to Solution.
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:
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.
Can you share a screenshot of your formula?
Is the Titel the normal SharePoint Title field (Single line of Text)?
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?
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.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.