Time Picker in Canvas App

[Santhosh88]

Hi Experts,

I want to build an app with time in and time out fields. I am fine with the date picker but how to implement date and time picker on the same filed. 

Please suggest. Attached is the screen shot for reference.

Thanks

Santhosh

[rubin_boer · Accepted solution]

hi @Santhosh88 

you can use a dropdown for hours, minutes and seconds:

dropdowns:

ddHour Items = ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23"]

DefaultSelectedItems = [Text(Hour(Now()),"")]

ddMinutes Items = = ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59"]

DefaultSelectedItems = [Text(Minute(Now()),"")]

ddSeconds  Items = ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59"]

DefaultSelectedItems = [Text(Second(Now()),"")]

Result:

Update or Patch is the datePicker & your hours, minute and seconds as per the comboboxes.

There you go.

Hope it helps,

R

[Santhosh88]

Thanks for your reply. I did your suggestion, but the selected value is not getting stored in the share point list, though its datetime column.

Please suggest.

[rubin_boer]

hi @Santhosh88 just a question, did you select the date or use the default date. the calculation in the update is valid from selecting the date.

[Santhosh88]

I clicked on calender icon and selected the date and hit on 'OK'.

Thanks

[v-qiaqi-msft]

Hi @Santhosh88,

Have you solved your problem?

I am confused that if the column is Date and time(including time), why don't you generate the form based on the data source directly, which will get you a date time picker by default.

Try to generate it automatically, do not manually add it.