dropdown needed in sequence with specific stop number based on another value

(0) Share

Report

Posted on by Km00

116

I'm building a app that has a field that requests vacation hours to be deferred into a new year.

I need this dropdown (pictured) to be in intervals of 4 and the max number to go up to 80 UNLESS the person has less the 80 available hours, then it would go up to the max number they have available (has to be divisible by 4 though).

I tried to use sequence but it doesn't have a option for Stop value, just where to start.

Obviously please tell me if there is a better way to do this, i'm having a mental block. Maybe just error validation or something within a text field.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

try this
Sequence(20;4;4)
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
i dont know how you get the hours, but try something like this:
If( numericnumber of hours(not a text) < 80; Sequence( numericnumber of hours(not a text) / 4; 4; 4 ) )
Km00 116 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect! Thank you! my mind was going in the direction but i just couldn't get it today for whatever reason. That worked, Thanks!