cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Manuel_O
Level: Powered On

DataTable to show last record

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

5 REPLIES 5
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: DataTable to show last record

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.

Manuel_O
Level: Powered On

Re: DataTable to show last record

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

Power Apps Staff CarlosFigueira
Power Apps Staff

Re: DataTable to show last record

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

BrianR
Level 10

Re: DataTable to show last record

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.  

Manuel_O
Level: Powered On

Re: DataTable to show last record

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?

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (4,836)