Multi Columns in gallery

[ASH3]

Hi friends

I'm struggling and need your help in creating gallery that contains 15 columns but not all is showing

I am using containers as it can be seen in figure below. I added horizontal container " main container " so I can scroll the header and the gallery together but it does not work. 

thank you

[DBO_DV]

Hey @ASH3 ,

Could you just explain a bit more what your scenario is?

Do you need absolutely to have all 15 columns on first sight? 

Do you interact with the individual records?

maybe you could make use of the Data Table (Table) control instead?

[ASH3]

Hi @DBO_DV 

I want to create a table exactly the same as excel table the i have so they can edit in the application. I tried to use Table control but it is for preview so I had to use the gallery. 

[DBO_DV]

There Is a not preview version of this the Data Table. 

Here is a Link to a tutorial that should be able to help you out : Power Apps Editable Table/Gallery like Excel (Tutorial) (youtube.com)

[Muzammil_069506]

Hi @ASH3 

can guide you on how to display multiple columns in a Power Apps gallery and achieve an Excel-like fixed pane feature. Here are the steps:

Displaying Multiple Columns in a Gallery:

Open Power Apps and create a connection to your data source.
Create a gallery and insert labels showing all columns in your data source1.
Place a label above the gallery with a different fill to act as a table header1.
Write each column name in the text property of the label and position them to match the data columns inside the gallery1.
Achieving Excel-like Fixed Pane Feature:

Add a vertical container and a subcontainer to the screen2.
Add a horizontal container inside the subcontainer and name it header container2.
Add labels to the header container for each column of the data source2.
Adjust the header container settings to start from the left, switch off the flexible height, and set the width and height based on the labels2.
Add a gallery below the header container and select the data source2.
Add labels to the gallery for each column of the data source and match the width and alignment with the header container2.
Adjust the gallery height to fill the app height minus the gallery y position2.
Add a horizontal scroll bar to the header container and the gallery and set the scroll value to be the same for both2.
Add a mod function to the gallery to alternate the row colors2.
Add a filter function to the gallery to filter the data based on a text input2.
Add a visible property to the scroll bar to show or hide it based on the scroll value2.

For more detailed information, you can refer to these resources:

• Power Apps Gallery Customization Tutorial
• Power Apps Gallery Design Tutorial
• How to Select MULTIPLE Items in Power Apps Gallery & PATCH
• Excel like freeze panes effect in Power Apps
• How to Make many “columns” in Gallery
• Gallery Displaying multiple columns
• Show a list of items in canvas apps

Feel free to mark my response as the solution by clicking Accept as solution if it resolved your issue, so others can find the answer. If you found the content helpful in other ways, you can show your appreciation by giving it a "Thumbs Up

[ASH3]

Yes in this tutorial he used only 4 columns but mine is more than 4 that not fit the screen 

also here is the table control, is there another one?

[DBO_DV]

Here is the Data Table: 

Have you tried simply expanding your Gallery? I Mean over the limits off your screen. This should add the scrollbar Automatically in a Container. 

[ASH3]

Hi @DBO_DV 

Why I don't have data table 😥

and yes I have tried your suggestion and it worked but when I scroll it right and left the header not align with it so I need the header also to be align

[DBO_DV]

@ASH3 ,

You need to add the Header in the same Container so that it stays aligned with the Gallery. 

[ASH3]

Yes that what I did but the scroll bar not showing even after enabling it