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.
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.
In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.