Hi all,
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.
Hi@Magoforrest,
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:
Sort(datasource,ID,Descending)
Hope it could help.
Regards,
Qi
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:
Sort(GRF.FINALRwyCcA,ID,Descending)
in wich my list is GFR my column is FINALRwyCca... i cant get it....ahhhhh
In my FINALRwyCca i have a number
And I am waiting for the result to appear on a label, not in a gallery label, I don't know if this info can help. thx
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 😞
Hi@Magoforrest,
Could you please try the Filter()?
Last(Filter(GRF.FINALRwyCcA,true,FINALRwyCcA.Value))FINALRwyCcA.Value
In addition, if you just want to sort the FINALRwyCca , you could sort as below:
Sort(GRF,FINALRwyCcA,Descending)
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.
Regards,
Qi
Hi@Magoforrest,
Could you please tell me that:
Qi
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
205 | |
70 | |
49 | |
49 | |
20 |
User | Count |
---|---|
252 | |
124 | |
84 | |
76 | |
73 |