How i can have one horizontal scroll bar that work for multiple horizontal galleries that are inside one vertical gallery

(0) Share

Report

Posted on by johnjohnPter

2,074 Season of Giving Solutions 2025

I have a Vertical gallery which contain many Horizontal galleries as follow:-

here are the end result:-

now for each horizontal gallery i have a separate horizontal scroll bar , so is there a way to have one horizontal scroll bar that will move all the horizontal galleries as we scroll through it?

Thanks

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

MissingLink 236 on at

Like
a
(0)

Report
Copy link

Link copied!

I presume that the source data for each gallery is coming from different tables?
Is there a reason that each gallery needs its own scrollbar? You could link them all to 1 'Master' scrollbar.

Assuming that you need separate scrollbars, I would try by setting the default X for each scrollbar to the X of the 'Master' scrollbar. Not sure how you would reset the individual defaults (after changing just one gallery - perhaps using a reset button?)
johnjohnPter 2,074 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@MissingLink thanks for the reply. no all the galleries have the same data source but different filtering. and yes i do not want to have multiple scroll bars, i am trying to find a way to have one scroll bar that will move all the horizontal galleries at once. did you get my point?
MissingLink 236 on at

Like
a
(1)

Report
Copy link

Link copied!

Hmm - I have just realized that you are using multiple HORIZONTAL galleries inside a VERTICAL gallery.
As far as I am aware, there is no way to control the scrollbar (other than the default manner in which it is implemented.)

Having said that, I have previously created a 'work-around' - but it's a LOT of work and I think that it wouldn't work in your scenario without first pivoting your data.
In short, this method reduces/increases the width of the leftmost column as the slider moves.

For what its worth, this is a (very brief) description of what I did.
1. Add VERTICAL gallery
2. Link to data source (In your case, the source would need to be filtered and pivoted first)
3. Arrange the fields horizontally. (X for some fields are far past the right edge of the gallery frame)
4. Set the X value of each field to PreviousField.X+PreviousField.Width
5. Add a SLIDER.
6. Set the width of each field (column) relative to the X value of the Slider.
For example, on one of my fields, the
Width = If(Slider1.Value*10 >253,
100-((Slider1.Value * 10)-253),
100)
johnjohnPter 2,074 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@MissingLink ok thanks , but what you mean by my data need to be pivoted?
MissingLink 236 on at

Like
a
(0)

Report
Copy link

Link copied!

In your case, I think that it's simply not practical to pivot the data.
Because your table (or Query) could have hundreds of columns - and depending on what database you are using, there might be a limit on the number of columns that you can have. (Unless you filter your data by a set number of days - say 90)

So each HORIZONTAL gallery, is displaying each ROW as a COLUMN, so you would need to convert the source data to make it fit into a VERTICAL gallery.
In other words - turn the data on its side.

So if your source is currently structured like
RECORD1 : NetworkName, WeekNum, DayName, DayNum
RECORD2 : NetworkName, WeekNum, DayName, DayNum
RECORD3 : NetworkName, WeekNum, DayName, DayNum

Then you could create a Crosstab query that changes the structure to

RECORD1, RECORD2, RECORD3.........
NetworkName, NetworkName, NetworkName
WeekNum, WeekNum, WeekNum
DayName, DayName, DayName
DayNum, DayNum, DayNum

This Video might help you.
Pivot Table in PowerApps (youtube.com)
MissingLink 236 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry - where I said:
Then you could create a Crosstab query that changes the structure to
I should have mentioned that the result would have to be a separate table for EACH Network.