Tables – How to create tables in Power Apps

Introduction

There are times when you need a table or list of records that aren't necessarily stored in any data source. An example of that is a left navigation menu. You can use separate buttons for each menu option but maintaining that becomes a problem. You will have to adjust the X and Y position of all of them, especially if it is a flyout menu.

Tip - Table function

The easiest way to create an ad hoc list of records is to use the Table function. For example, to create a filter menu that filters records based on their status, use the Table function to create a gallery/list of the statuses.

To illustrate this, here is a quick example:

The Items property of the horizontal gallery is:

Table(
    {Value: "A"},
    {Value: "B"},
    {Value: "C"},
    {Value: "D"},
    {Value: "E"},
    {Value: "F"},
    {Value: "G"},
    {Value: "H"},
    {Value: "I"},
    {Value: "J"},
    {Value: "K"},
    {Value: "L"},
    {Value: "M"},
    {Value: "N"},
    {Value: "O"},
    {Value: "P"},
    {Value: "Q"},
    {Value: "R"},
    {Value: "S"},
    {Value: "T"},
    {Value: "U"},
    {Value: "V"},
    {Value: "W"},
    {Value: "X"},
    {Value: "Y"},
    {Value: "Z"}
)

To read more the Table function, click here.

There are other ways ad hoc tables can be created. Taking the above scenario as an example, a simpler way to do that is to use the following as the Items property:

[
    "A",
    "B",
    "C",
    "D",
    "E",
    "F",
    "G",
    "H",
    "I",
    "J",
    "K",
    "L",
    "M",
    "N",
    "O",
    "P",
    "Q",
    "R",
    "S",
    "T",
    "U",
    "V",
    "W",
    "X",
    "Y",
    "Z"
]

Stay tuned for the remaining 6 tips!

Recent articles

1. A-Z: 26 tips! Learn how to improve your Power Apps!
2. Add Picture vs Camera Control – Who is the winner?
3. Background images for Power Apps screens – the right way!
4. Combo box or Dropdown? - Who is the winner?
5. Delegation in Power Apps – How to identify and test!
6. Edit vs Display – Which is the better form?
7. Formulas – How to learn the 170+ Power Apps formulas?
8. Galleries vs Data Tables – How to pick between the two in Power Apps?
9. Hyperlinks – How to launch web pages & apps in Power Apps!
10. Icons – How to increase performance!
11. Jump start – How to speed up Power Apps dev with components!
12. Keyboard – How to control the keyboard type on mobile
13. LastSubmit – How to fetch the last submitted record in Power Apps
14. Media controls in Power Apps – How to improve user experience!
15. New screens – How to speed up Power Apps dev using templates!
16. OnStart – How to optimize app loading experience!
17. Phone camera – How to switch cameras on Power Apps mobile!
18. Quotes – Should you use single or double in Power Apps?
19. Reset – How to reset a Power Apps gallery?
20. SaveData – How to persist your Power Apps sessions!