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
Solved! Go to Solution.
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)
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)
This is nice, but can you create a time picker with AM/PM on a 12 hour basis. Example "1:23 PM"?
You could add a toggle that would allow users to pick between AM/PM
@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."
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.
Again how to set a default value for Dropdown?
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!!
User | Count |
---|---|
261 | |
126 | |
101 | |
49 | |
47 |