web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Combine gallery pagina...

Power Apps

Answered

Combine gallery pagination and sortbycolumns

(0) Share

Report

Report

Posted on by RM-30040732-0

545

Hello!

Wondering if someone can help me combine these two formulas please!

On the Item property of my Gallery:

I have this already (for pagination):

LastN(FirstN('Safety Information',varPage),RoundDown(Gallery2.Height / Gallery2.TemplateHeight,0))

And I want to filter the list using this:

SortByColumns(Filter('Safety Information', Status.Value = "Pending"),"Created",Ascending)

I have tried && and And(.... but neither work! Both statements work great on their own but I really want to use both!

Any help greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

cha_cha 4,932 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hello @RMD211

How about
LastN( FirstN( Sort( Filter('Safety Information', Status.Value = "Pending"), Created) 'Safety Information',varPage) ,RoundDown(Gallery2.Height / Gallery2.TemplateHeight,0) )

Was this reply helpful? Yes No
RM-30040732-0 545 on at

Like (1)

Report
Copy link

Link copied!

Worked a treat without the second 'Safety Information' reference! Thanks so much! I also added Filter('Safety Information', Status.Value = "Pending") to the other buttons that work on the pagination and works there too.

Was this reply helpful? Yes No

Join the conversation