I am sure that my question is dumb, but I am stuck......
I have an Excel table that I fill in with another app, now I am trying to visualize it from a gallery in order from the last insertion on the table... I tried Sort(datasource, Descending) but it doesn't work...any suggestions? THX in advance
Every table should have an ID number incremented sequentially as a new record is added. This allows you to sort it descending. It also allows relationships between tables based on their ID.
Do you want to sort your records in your Excel table by the last updated time?
Could you please tell me that if there is a Date related column that could identify the time you update the record?
I think there is something misunderstood with the Sort() function.
Sort( Table, Formula [, SortOrder ] )
The formula you provided Sort(datasource, Descending) is lack of the required part, Column name.
So if you want to sort the table by the time of update, you should created a column to store the created date time. Or if you do not need to edit the existing record, you could directly create a primary key like ID in the table. Then you could sort the Table by setting the Items property of the Gallery as below:
Hope it could help.
thx for the answer, it looks simple but i am still having problems, since a posted i moved my app on a sharepoint list and i am trying this:
in wich my list is GFR my column is FINALRwyCca... i cant get it....ahhhhh
i got something working using a lookup:
LookUp(GRF.FINALRwyCcA,true,FINALRwyCcA.Value).... but i am getting the first element on my list... i need the last 😞
Could you please try the Filter()?
In addition, if you just want to sort the FINALRwyCca , you could sort as below:
Could you please tell me that if the FINALRwyCca is a LookUp column or a Number?
I think you have made the issue more complex.
Hope it could help.
Could you please tell me that:
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Did you miss the call? Check out the recording here!