web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter gallery by last...

Power Apps

Answered

Filter gallery by last 15 entries

(0) Share

Report

Report

Posted on by Matt383

407

I have a gallery with the datasource set to Sharepoint. I am also filtering by user and selected admin. This is the syntax i have in the Items, it works fine.

If(User().Email in varAdminEmail, KBXoffline, Filter(KBXoffline, 'Created By'.Email = User().Email))

I want to also show only the last 15 entries. I have tried using LastN(KBXoffline, 15), which works when put in Items by itself, however i can not seem to be able to add it to the existing syntax.

If(User().Email in varAdminEmail, KBXoffline, Filter(KBXoffline, 'Created By'.Email = User().Email));
LastN(KBXoffline, 15)

Can anyone please assist,

KR's,

Matt383

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Matt383

Here’s the code you should add to filter on the 1st 15 entries.

FirstN(Sort(If(User().Email in varAdminEmail, KBXoffline, Filter(KBXoffline, 'Created By'.Email = User().Email)), Created, Descending), 15)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Matt383 407 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Mdevaney,

Thats what i was looking for

Matt383

Was this reply helpful? Yes No

Join the conversation