Hello,
How can i get the 2 last added items into the gallery?
Sort(Filter(ExpensesCollect,PlanTitle = Text(CurrentBudgetItem)
)
,'Id (ID)',Descending)
This code gives me all the records.
Thank you
Hi @TimmyBoy,
Do you want the Gallery only display the last two records?
If so, I think you could use the Modified column that records the latest modified date time for each item.
FirstN(Sort(Filter(ExpensesCollect,PlanTitle = Text(CurrentBudgetItem)
)
,Modified,Descending),2)
Or you could use the ID column as the sort column:
FirstN(Sort(Filter(ExpensesCollect,PlanTitle = Text(CurrentBudgetItem)
)
,'Id (ID)',Descending),2)​
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 2