Create dynamic lists, numbered sequences, or repeating values in Power Apps using the SEQUENCE function. This guide walks you through examples for numbers, dates, and text labels, with tips and best practices for production-ready apps.

Table of Contents

1. What the SEQUENCE Function Is
2. Syntax and Parameters
3. Step-by-Step Examples
   • Numbers
   • Dates
   • Text Labels
4. Common Use Cases
5. Tips and Best Practices

1. What the SEQUENCE Function Is

The SEQUENCE function generates a table of sequential values. Unlike manually creating lists, SEQUENCE produces numbers, dates, or text sequences dynamically for galleries, dropdowns, or controls.

💡 Tip: Great for dashboards, reports, or repeating UI elements dynamically.

2. Syntax and Parameters

SEQUENCE(rows, columns, start, step)

Parameter	Description	Default
rows	Number of rows	Required
columns	Number of columns	1
start	Starting value	1
step	Increment value	1

3. Step-by-Step Examples

Example 1️⃣: Single Column Number Sequence

SEQUENCE(5)

Output:
1
2
3
4
5

Example 2️⃣: Multiple Columns Number Sequence

SEQUENCE(3, 4)

Output:

1   2   3   4
5   6   7   8
9  10  11  12

💡 Pro Tip: Use columns to display sequences in a table or gallery format for dashboards.

Example 3️⃣: Custom Start and Step

SEQUENCE(5, 1, 10, 2)

Output:
10
12
14
16
18

Example 4️⃣: Date Sequence

ForAll(
    SEQUENCE(7),
    DateAdd(Today(), Value - 1, Days)
)

Output (assuming today is Sept 5, 2025):

05-Sep-2025
06-Sep-2025
07-Sep-2025
08-Sep-2025
09-Sep-2025
10-Sep-2025
11-Sep-2025

📌 Tip: Use with DateAdd to generate dynamic schedules or calendar events.

Example 5️⃣: Text Labels

ForAll(
    SEQUENCE(5),
    "Item " & Value
)

Output:

Example 6️⃣: Reverse Number Sequence

Item 1
Item 2
Item 3
Item 4
Item 5

SEQUENCE(5, 1, 10, -2)

Output:
10
8
6
4
2

💡 Tip: Negative steps allow reverse counting, useful for countdowns or reverse numbering.

---

Example 7️⃣: Two-Dimensional Number Table

SEQUENCE(3, 3, 1, 5)

Output:
1   6  11
16  21 26
31  36 41

Screenshot placeholder: ![2D Number Table](URL-to-your-screenshot)

📌 Tip: Use 2D sequences in galleries or grids for visual reporting.

---

4. Common Use Cases

• Dynamic dropdowns or galleries
• Repeating UI elements with ForAll(SEQUENCE(...), ...)
• Iterations for calculations or validation
• Dynamic reporting tables for dashboards

💡 Pro Tip: Pair SEQUENCE with AddColumns or ShowColumns to create structured tables.

---

5. Tips and Best Practices

1. Combine with ForAll for dynamic collections.
2. Use AddColumns or ShowColumns to structure sequences.
3. Avoid very large sequences to keep apps performant.
4. Negative steps allow reverse or decrementing sequences.
5. Combine with DateAdd, Concatenate, or Text for versatile outputs.

---