web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Get last added record ...

Power Apps - Building Power Apps

Answered

Get last added record into gallery?

Like (0) Share

Report

Report

Posted on 4 Jan 2023 04:30:54 by TimmyBoy

997

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

TimmyBoy 997 on 04 Jan 2023 at 04:58:08

Like (0)

Report

Re: Get last added record into gallery?

Hello @v-qiaqi-msft
Cool ,thanks

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on 04 Jan 2023 at 04:47:27

Like (2)

Report
Re: Get last added record into gallery?

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)

Was this reply helpful? Yes No