Model driven app page - combobox 'modifiedon' as Date formatted

(0) Share

Report

Posted on by Kosenurm

802

Hi there,

I have a 'canvas page' within my model-driven app. In this page, there is a ComboBox, double, whereby I am including one column (test) as the primary, and then I want to display the 'modifiedon' value as the Secondary item.

I have done this as follows:

["new_partyinvolved", "modifiedon"]

But the modifiedon value then displayed in the combobox is "1660048378000" - so the long-form of the date.

How can I amend this so that the modifiedon appears as dd-MM-yyyy (with no time)?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Kosenurm

I'd try adding the formatted date to the Items property of the Combobox

AddColumns(YourDVTable, "ModifiedOnFormatted", Text('Modified On', "dd-mm-yyyy") )

You can then modify the displayfields property like so, and that should hopefully work.

["new_partyinvolved", "ModifiedOnFormatted"]

Was this reply helpful? Yes No
Kosenurm 802 on at

Like (0)

Report

Fab, thank you. Is it possible to then Sort the combobox from newest to oldest based on ModifiedOnFormatted?

Thanks
K.

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
@Kosenurm,

Yes - if you sort by 'Modified On' rather than the formatted value, that should give you the result that you want.

Sort( AddColumns(YourDVTable, "ModifiedOnFormatted", Text('Modified On', "dd-mm-yyyy") ), 'Modified On', Descending )

Was this reply helpful? Yes No