cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gog
Level: Powered On

Is there a TIME PICKER?

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

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Is there a TIME PICKER?

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)

View solution in original post

2 REPLIES 2
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Is there a TIME PICKER?

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)

View solution in original post

PowerApp101
Level: Power Up

Re: Is there a TIME PICKER?

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

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,041)