Unanswered

Freeze columns within single gallery

(2) Share

Report

Posted on by LB-08081540-0

I have an app that looks something like the one below (with approximately 60 additional columns). Here, the user can select a single record or multiple records based on the name (using the search box), and then select those rows using the 'check all' option or individual checkboxes. This allows the user to update the state and country based on the pre-populated dropdown values. Once submitted, these changes will be written to a SharePoint list.

Everything is working as expected, but the main problem is with the scrolling/freezing functionality. As I have close to 60 columns, State and City are somewhere between the 50th and 51st positions. I am using a slider to scroll to the right, and that's when things get complicated. The user loses visibility of the ID, customer ID, and customer name, which they have selected while updating the dropdown values. I tried to split this into multiple galleries and used up and down arrows for navigation, bringing these galleries into sync with each other, but that's impacting all other functionalities. Therefore, I want to stick to one single gallery.

Is there any workaround for implementing a freeze functionality for the first 5-6 columns?

Categories:

General Questions

Dataflows

All responses (2)

Answers (0)

LB-08081540-0 12 on at

Like (0)

Report
Freeze columns within single gallery

I have implemented everything mentioned under 'Custom Freeze Columns with Two Galleries,' but it is causing multiple functionalities that were working perfectly fine in one gallery to mess up:

Unable to filter records from both galleries using the search box.

Unable to submit changes using the submit button.

Unable to select multiple items using the check box from both galleries
Robu1 1,164 Super User 2025 Season 1 on at

Like (0)

Report

Freeze columns within single gallery

Hi LB-08081540-0,

Thank you for choosing Microsoft Community.

It sounds like you are dealing with a complex interface.

Use a Data Table Control:

Consider using a Data Table control instead of a Gallery, as it has built-in support for freezing columns.

Custom Freeze Columns with Two Galleries:

Create Two Galleries: One for the fixed columns (e.g., ID, customer ID, customer name) and one for the remaining columns.

Sync Galleries: Use the same data source for both galleries to keep them synchronized.

Align Galleries: Place the galleries side by side and align them properly.

Scroll Synchronization: Use a slider or scroll bar to control the horizontal scroll of the second gallery.

Horizontal Scrolling with Fixed Columns:

Container for Fixed Columns: Create a container for the fixed columns and place the key identifiers inside it.

Scrollable Container: Create another container for the scrollable part of the gallery and place the remaining columns inside.

Sync Scroll: Use a slider or scroll bar to control the horizontal scroll of the scrollable container while keeping the fixed columns static.

If this resolves the issue, Pls mark as solved to enable other users with a similar issue to find it.

Happy to help.

Robu1🤩