Unanswered

Slider max value increase decrease based on hide unhide columns

(0) Share

Report

Posted on by 70000075

Hi,

I am facing the issue of slider control, Slider max value increase or decrease based on hide unhide columns, I have create gallery based on slider control for gallery columns scrollable left right, Max value is 5575, my requirement is if any column hide (etch column width is 175) Max value reduce = 5400, If any column unhide 5400+175=5575,

#Hide Unhide columns based on condition check box select...

Ref. below screen shot no any column Hide

Ref. below screen shot last two column Hide

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Fredrik_A 3,644 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Use a variable that starts at the correct width and then counts the hide/unhide part, then add/subtract 175 based on the event.

Was this reply helpful? Yes No
BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
HI @70000075 ,

It seems like you are using a gallery where the user can select which columns to show/hide. If so, you can count the number of checked items in that, multiply by 175 and add to a base value:

Slider.MaxValue = 2000 + (CountIf(Gallery.AllItems, CheckBox.Value) * 175)

In the above example I have set the base value to 2000, but you can change that to whatever suits you best.

Of course you can turn this around and deduct the number of unchecked items, multiplied by 175, from 5575 as well:

Slider.MaxValue = 5575 - (CountIf(Gallery.AllItems, !CheckBox.Value) * 175)

However, if you ever want to add new columns to your app, the first option will adapt to that without intervention, whereas you'll have to change the maximum value for the second option.

Was this reply helpful? Yes No
70000075 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry I don't understand, where to use this formula, in the slider Max function or checkbox, please provide the brief details...

Thank you so much...

Was this reply helpful? Yes No
BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @70000075 ,

This is to be used for the MaxValue property of the slider.

You probably have to make some changes to the code:

- Do not include "Slider.MaxValue =" this was to indicate which property to use

- "2000" needs to be replaced with a base value that makes sense. Since I don't know how many columns you have, I had to guess on this.

- "Gallery" should be replaced with the name of the gallery where you selected to show/hide columns

- "CheckBox" should be replace with the name of the checkbox in abovementioned gallery.

Was this reply helpful? Yes No
70000075 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Not working,
In the manual create gallery there are more than 30 columns and each columns has a separate check box to Hide and Unhide columns, all those checkbox names are different, if I hide some columns there is space on the right side of the application, which is MaxValue fixed value in the slider.

Was this reply helpful? Yes No
BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @70000075 ,

What is the name of the checkbox control in you gallery? You seem to have not changed that name yet in the formula:

Was this reply helpful? Yes No