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.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.