Unanswered

DataTable to show last record

(3) Share

Report

Posted on by Manuel_O

Hi,

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?

best,.

manuel

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

CarlosFigueira on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Manuel_O 32 on at

Like (0)

Report
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:

SortByColumns(Tabelle2;"Stamp",SortOrder.Descending)
But nothing happens. Maybe a syntax-fault?

best,
Manuel

Was this reply helpful? Yes No
CarlosFigueira on at

Like (0)

Report
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).

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Manuel_O 32 on at

Like (1)

Report

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:
25.01.2018 20:39
...
18.09.2018 12:49
...
15.02.2018 23:33

Data Source is an excel table. I already changed cell formatting to date but is does not seem to have any effect... any ideas?

Was this reply helpful? Yes No
Nuchem 128 on at

Like (0)

Report

I reckoned it's either going to be the last modified or the last created so the trick is to remember that a sort function doesn't modify the data source in place; therefore it's got to be used with the ClearCollect to create a new collection out of the sorted data source that you're operating on:

ClearCollect( dataTableSource, Sort(backEndSource, If(Modified = Created , Created , Modified ) , Descending) );
Note: I'm using SharePoint lists so they come with 'Created' and 'Modified' fields.

Was this reply helpful? Yes No