web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery to only...

Power Apps

Answered

Filter Gallery to only show last 10 entery

(0) Share

Report

Report

Posted on by David1966

97

How would i go about to filter current user and only show last 10 enter items on a SharePoint list I try Chatgpt but no luck.

here formula so it show current user by email

Filter('Snowy Drone Request Data',Email = User().Email)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

realwillwright 772 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @David1966

The following should provide the answer it is taken from First, FirstN, Index, Last, and LastN functions - Power Platform | Microsoft Learn

LastN( Sort( Filter( 'Snowy Drone Request Data', Email = User().Email ), "Modified", SortOrder.Descending ), 10 )

I've added a Sort on the data as well so it is sorted by last modified, I may have the sort order the wrong way round so it might need to be Ascending

-------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Heya Will!

I think they mean the 'last ten that were submitted' i.e. the most recent ten, so that should probably be a FirstN rather than a LastN 🙂

Cheers,

Sancho

Was this reply helpful? Yes No

Join the conversation