Sequence function

(0) Share

Report

Posted on by BrosJr.

Hi. I have a table with a numeric column.

I want a dropdownbox to get a number from this column and list all number from 1 to to the recorded number.

How to achieve this?

Thank You.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Nicbo 145 on at

Like (1)

Report
Copy link

Link copied!

If you are displaying the table in a gallery and want a dropdown on each row you can use Sequence(ThisItem.RecordedNumber)

If your dropdown is outside of the gallery you can use Sequence(GalleryName.Selected.RecordedNumber)

Hope it helps!

Was this reply helpful? Yes No
Verified answer

SpongYe 5,903 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @BrosJr

To achieve your goal, you can use the following steps
Create a dropdown control and set its Items property to your table column that contains the numbers.
Create another dropdown control and set its Items property to

ForAll(Sequence(Dropdown1.Selected.Value), Value)
This will create a table of numbers from 1 to the selected value in the first dropdown.

You can now use the second dropdown to select any number from the generated sequence.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
BrosJr. 65 on at

Like (2)

Report
Copy link

Link copied!

Thank you, It worked like a charm

Was this reply helpful? Yes No