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)

Sort by

Verified answer

GuestUser 9 on at

Like (0)

Report
Copy link

Link copied!
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,906 Moderator on at

Like (1)

Report
Copy link

Link copied!

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