web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps List with 5 minute seq...

Power Apps

Answered

List with 5 minute sequence

(0) Share

Report

Report

Posted on by GuestUser

9

Hi experts,

I am trying to modify an existing solution to generate a list of hours/minutes at 5 minute intervals: https://jgvjg48436.lithium.com/t5/Building-Power-Apps/sequencing-24-hour-time-for-a-dropdown/td-p/1245445

ForAll(
    Round(Sequence(289,0,0.0833),2),
    Text(RoundDown(Value,0),"00")&":"&Text(Mod(Value*60,60),"00")
)

The above modification is what I have come up with it but the results are not correct. Could anyone help steer me into the correct direction?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

GuestUser 9 on at

Like (0)

Report
Resolved. Needed to add another 3 to 0.0833:

ForAll(Round(Sequence(288,0,0.08333),2),Text(RoundDown(Value,0),"00")&":"&Text(Mod(Value*60,60),"00"))

Was this reply helpful? Yes No
Suggested answer

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (1)

Report

You could do an extension of this where Sequence is used to generate 5 minute intervals which are added to the time

ClearCollect(TheTimesList, Sequence(20, 5, 5));

ClearCollect(TimeIncrement, AddColumns(TheTimesList, TheTime, DateAdd(DateTimeValue("12/20/2024 12:00 AM"), Value, TimeUnit.Minutes)));

You can then extract the time from the datetime if that is your requirement

Was this reply helpful? Yes No

Join the conversation