PowerApps: How to make gallery look like a data table with Horizontal scroll bar in Vertical gallery ?

Ragavan Rajan
2 min readSep 20, 2020

--

Straight to the point:

Step1: Insert Label as header > Choose Second label header (In this case Area). Set its property X formula to below

Label14.X+Label14.Width

Note: Here label 14: refers to Site Status

Snippet of Gallery Vertical control

Repeat the steps and set X property formula for all label headers referring to the previous label header name. Ex: For Urban Label > Set X Property formula to

Label14_1.X+Label14_1.Width

Step 2: Insert vertical gallery and stretch it to screen window size.

Step 3: Select Gallery and insert labels for your data fields value

Step 4: Insert Slider on your screen and set below properties to look like a horizontal scroll bar

Select Slider and set the following property values

Step 5: Select First label header (Label referring to Step 1) and set X property formula to

43-Slider2.Value

Step 6: Click gallery and set X property formula to

0-Slider2.Value

Step 7: Click gallery and Set width property formula to

1353+Slider2.Value

Note: Here 1353 indicates screen size

Why we need to do this workaround ?

By default PowerApps doesn’t have horizontal scroll bar in Vertical gallery. You can upvote in the following link

Other use cases:

You have option for DataTable control but it doesn't support calculations depends on the data source your are using. Ex: SharePoint list as data source.

--

--

Ragavan Rajan
Ragavan Rajan

Written by Ragavan Rajan

Microsoft Business Applications MVP|5X PowerPlatform Superuser |Solution Architect|Full Stack Developer|Modern web developer, etc.

Responses (2)