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

I have the same question (0)

All responses (5)

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (1)

Report

Thank you works perfectly

Was this reply helpful? Yes No
taylorritchie 2 on at

Like (0)

Report

Can you detail how to create a next button?

Was this reply helpful? Yes No