Power Platform Community Forum Thread Details

Hi All,

I have a table in dataverse with various columns including a column called 'Date'.

I have made a canvas app which has two screens - the first screen has a gallery which has an overview of some important columns, When a column in the row is clicked it opens screen two which populates textboxes and combo boxes with the data of the selected row.

This works fine however I have a problem with the 'Date' column. I would like to display the time from the gallery in combo boxes.

I have tried

Gallery1.Selected.Date

in the Default field of the hours and minutes combo boxes but this just gives me 00:00.

Can anyone help?

Thanks

Categories:

General Questions

@AshleyTaylor,

You can use the following code for the comboboxes:

//Hours combobox

//Items property (display hours starting from 00 until 23)
ForAll(
 Sequence(24),
 Text(
 Value - 1,
 "00"
 )
)

//DefaultSelectedItems property
//In case of a dropdown this would be Text(Hour(Gallery1.Selected.Date),"00") in the Default property
[Text(Hour(Gallery1.Selected.Date),"00")]

//Minutes combobox

//Items property (display minutes starting from 00 until 59)
ForAll(
 Sequence(60),
 Text(
 Value - 1,
 "00"
 )
)

//DefaultSelectedItems property
//In case of a dropdown this would be Text(Minute(Gallery1.Selected.Date),"00") in the Default property
[Text(Minute(Gallery1.Selected.Date),"00")]

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!