Answered

Is there a TIME PICKER?

(0) Share

Report

Posted on by gog

After 2 days googling and searching at this forum I am still lost.

I have a datepicker that I use for filtering my results. The results' datasource is the Case entity at the CDS. Right now that field is of the type "Date" and NOT "DateTime".

My questions is, I really want it to have a time specified per each case so our support workers can filter their upcoing case byt BOTH date and time. Please help me how to insert this function on the EDIT CASE screen and together with the datepicker in the filter screen.

Thank you

Best regards
Goog

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

CarlosFigueira Microsoft Employee on at

Like (14)

Report
Copy link

Link copied!
Currently PowerApps doesn't have a time picker (or a date and time picker) - feel free to vote for some of the current feature requests in the PowerApps Ideas board for that to increase the priority for the team.

For now, you can use a pair of dropdown controls (Hour and Minute) to let the users specify the time. They will have their Items property defined as such:
DropdownHour.Items: ["00","01","02",...,"22","23"] DropdownMinute.Items: ["00","01","02",...,"58","59"]
If you don't want that granularity for minutes, you can also have only certain values, such as ["00", "05", "10", ..., "50", "55"]. If you want to create a Time value from those controls, you can use the expression
Time( Value(DropdownHour.Selected.Value), Value(DropdownMinute.Selected.Value), 0)
Or if you have a date picker and you want to create a date/time value (which you then can use to compare against date/time columns):
DatePickerDate1.SelectedDate + Time( Value(DropdownHour.Selected.Value), Value(DropdownMinute.Selected.Value), 0)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is nice, but can you create a time picker with AM/PM on a 12 hour basis. Example "1:23 PM"?

Was this reply helpful? Yes No
kuclimber 2 on at

Like (0)

Report
Copy link

Link copied!

You could add a toggle that would allow users to pick between AM/PM

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (14)

Report
Copy link

Link copied!

@gog
I have written an article on how to make a time picker in Power Apps with step-by-step instructions. If you want to build the time picker shown in the image below please click on the link to my article.

Link to article:

https://matthewdevaney.com/make-a-time-picker-in-power-apps/

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

1 people found this reply helpful.

Was this reply helpful? Yes No
mtools 11 on at

Like (0)

Report
Copy link

Link copied!

Take a look at this, let me know if you'd like to know how.

Was this reply helpful? Yes No
BenGin 75 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the instructions. I am experiencing some weird behaviour. In the Component, it works fine whre I can click on the hours, minutes or AM/PM and they become selected. But when I add the component to a screen, the component selections requires double-click before they are set. If I just click once on the hours, it will not select. I have to double-click. Same goes for the minutes and the hours.

Was this reply helpful? Yes No
gnanavel001 2 on at

Like (0)

Report
Copy link

Link copied!

Again how to set a default value for Dropdown?

Was this reply helpful? Yes No
AN-04021424-0 4 on at

Like (0)

Report
Copy link

Link copied!

You are soo right... this is a common control so why is it not available in PowerApps? Well Thank you for the tutorial on how to build! I was just thinking I need something cleaner than a drop down for my users... too long a selection list in my opinion. Thanks!!

Was this reply helpful? Yes No
PowerBuilder 30 on at

Like (1)

Report
Copy link

Link copied!
@gog wrote:
After 2 days googling and searching at this forum I am still lost.

I have a datepicker that I use for filtering my results. The results' datasource is the Case entity at the CDS. Right now that field is of the type "Date" and NOT "DateTime".

My questions is, I really want it to have a time specified per each case so our support workers can filter their upcoing case byt BOTH date and time. Please help me how to insert this function on the EDIT CASE screen and together with the datepicker in the filter screen.

Thank you
Best regards
Goog
I had the same requirement but I had to use a dynamic start time of 12 hours on the hour. This one liner gave me what I need and sure it will assist someone.

ForAll(Sequence(12,0),Collect(col_Timing,{Id:GUID(),Time:TimeValue("06:00")+TimeValue(""&ThisRecord.Value&":00")}))
The sequence can be adjusted to the amount of hours you need and obviously add more fields.

Was this reply helpful? Yes No