I have an PowerApp showing a datatable. (Excel table). Everytime the user pushes a button, a line to the table will be added. It works fine, but the data table keeps showing the first records so if the user wants to see the new things he will have to scroll down. Is there a possibility that the DataTable shows the last records/the lower part of the table by default?
This is not possible currently - please create a new feature request in the PowerApps Ideas board for that.
One possible workaround would be to have the items in the table sorted by creation date (if the table currently doesn't have such a column, you'd need to add it) in descending order. This way, when a new item is added, then it would appear on the top.
Thank you, this is a good idea.
As a beginner in PowerApps, I'm just not sure how to achieve this.
I tried as a behavior in Browse Screen 1 - on visible:
But nothing happens. Maybe a syntax-fault?
You can have this expression in the Items property of your data table:
SortByColumns( Tabelle2; "Stamp"; SortOrder.Descending)
When you use the SortByColumns function (and most other table-related querying functions), it doesn't change the underlying table; instead, it will return a new collection (table) with the sorting applied. So if you want to display a sorted collection in your data table, you apply the sort right there where it needs to be used (in its Items property).
While I use Data Table "in a pinch" to quickly check my data (and thankfully with a recent update several weeks ago, it no longer seems to hold stale data, but now refreshes properly :-)), due to its many limitations, I've created custom galleries for this instead.
Its definitely a bit more work to use a gallery in this matter, but gives you a lot more flexibility (ie: can use HTML text in the fields, controls, etc). Would be nice if there was a template for a "Vertical gallery" but where the default items are spaced horizontally (ie: mimicking a data table). Would make it easier to add items, but doing so by customizing the gallery isn't too hard. Still more difficult than a Data Table, but I find much better results and more flexibility.
Would love to see additional functionality on the Data Table though, as this would alleviate the need for what I'm doing in many cases, such as what you're looking for, etc.
The sort formula works on a text field (In/Out), but unfortunately not on that "stamp" field. It seems not to be sorted at all:
Data Source is an excel table. I already changed cell formatting to date but is does not seem to have any effect... any ideas?
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand