Next button OnVisible

(0) Share

Report

Posted on by Lefty

1,625

Hey all,

I have a Next button and I am looking to hide it after it has got to the end of my pagination results, but cannot get the right formula.

I have a dropdown with the user having the ability to increase the pagination to 30 called: DdResultsPP

I have a textbox, with its value set to:

"Total Results: " & vSearchResults.totalrows

My results are coming from a PowerAutomate flow

I have set my previous buttons visible property:

If(vFrom=0, false, true)

This was working, but while writing this, has stopped working!

My OnSelect on my next button is:

Set(vFrom,vFrom+DdResultsPP.Selected.Value);Select(BtnSearch)

I have a label displaying the total results from the flow:

"Total Results: " & vSearchResults.totalrows

How do I hide my Next button when there are no more results to display as the flow has searched all the results it can display?

My results are being displayed in a gallery, but I don't think the formula for the next buttons visible property makes any difference?

Thank You

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @Lefty

can u try this please:
Visible property

vFrom + DdResultsPP.Selected.Value < vSearchResults.totalrows

This formula evaluates to true when there are more results to display beyond the current set being displayed, making the "Next" button visible. When the sum of vFrom and DdResultsPP.Selected.Value is equal to or greater than vSearchResults.totalrows, it means you've reached the end of the results, and the formula evaluates to false, hiding the "Next" button.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

hey @mmbr1606

Thank you for responding so quickly, I have tried and on the last part of the formula i get the following error:
Invalid argument type. Expecting one of the following: Number, Decimal, Date, Time, DateTime, UnTypedObject
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Value(vFrom) + Value(DdResultsPP.Selected.Value) < Value(vSearchResults.totalrows)

Please try this modification

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
Lefty 1,625 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you works perfectly
taylorritchie 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you detail how to create a next button?