Set Quantity Dropdown List with number range

[nmoffatt]

Hi,

I'm looking to add a simple Dropdown List to select "Quantity" with a number range. Is there a simple way to do this without creating a table with the numbers?

This seems so simple that its hard to find an answer to lol 

Thanks!

[RandyHayes · Accepted solution]

@nmoffatt 

I am not sure entirely what you mean on the range of numbers.  If you mean a sequential list of numbers then yes...you can set your items property of your dropdown to:

Sequence(maxNumber)

This will produce a list from 1 to the maxNumber you specify.

I hope this is helpful for you.

[nmoffatt]

That did it! Thank you @RandyHayes 

[JSnapp]

blankity blank

[RandyHayes]

@JSnapp 

Is your reply related to this post or to your other post you started?

[Stephen_Putnam]

Great Answer!! Do you know a way of setting the minumum number as well? i.e. a sequential range of 75 through 150?

[Stephen_Putnam]

I found the answer for anyone looking.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-sequence

The help file is great if you know what you are looking for!