Answered

Filter gallery by last 15 entries

(0) Share

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 (2)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@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 (0)

Report

Thanks Mdevaney,

Thats what i was looking for

Matt383

Was this reply helpful? Yes No