Excel like freeze panes effect in Power Apps

Excel like freeze panes effect in Power Apps

Hey Everyone,
In this video I will walk you through a step-by-step process on how to create an Excel like freeze panes effect in Power Apps canvas studio. This includes freezing a column on the left and allowing the scroll functionality to view the remain columns on the right. I've also demonstrated how to "lock" two galleries such that they scroll together simultaneously.

Table of contents
- Introduction (0:00)
- Template fill example in Excel (0:47)
- Start building the general freeze pane (1:21)
- Add the main container (2:37)
- Add the header container (3:43)
- Add the gallery (9:04)
- Adding the horizontal scroll (19:24)
- Adding the mod function (25:15)
- Reducing the row height (27:40)
- Start building the freeze pane with rows and columns (28:42)
- Build the left columns (29:12)
- Build the right columns (31:36)
- Adding the scroll lock (36:23)
- Adding the filter function (42:46)
- Adding the visible property for the top arrow (45:00)
- Conclusion (46:11)