Building Power Apps

Change date format in Dropdown List in Powerapps

(1) Share

Report

Posted on by RVoller

Hi,

Request is to change the format of the date in a drop down list.

The items property of the dropdown list is :

SortByColumns(
    Filter(
        'Company Vehicle FBT Returns',
        Driver = drpDriver.SelectedText.Value
    ),
    "FBTReturnPeriod",
    SortOrder.Descending
)
 
The dropdown list looks like this :
 
I need the date to be formatted as "dd/mm/yyyy".  So : 8/31/2024 should display as 31/8/2024.
 
I have tried 
For All function, but this produces duplicates as well as distinct.  Nothing seems to work.
 
Anyone have a solution?
 
Kind regards
 
 
Rene Voller

Categories:

General Questions

All responses (2)

Answers (0)

Suggested answer

CA1105 182 on at

Like (0)

Report
Change date format in Dropdown List in Powerapps

Can you try something like below?
SortByColumns( Text(Filter( 'Company Vehicle FBT Returns', Driver = drpDriver.SelectedText.Value ),'dd/MM/yyy'), "FBTReturnPeriod", SortOrder.Descending )
Suggested answer

FLMike 26,301 on at

Like (2)

Report

Change date format in Dropdown List in Powerapps

Hi

You could use an AddColumns, where the new column would be the column that you would Format the other column into the Format you want

This would allow you to Pick this New Column to show in the dropdown versus the original

Please Check this out.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-table-shaping#:~:text=The%20AddColumns%20function%20adds%20a%20column%20to%20a%20table,%20and

and in the New Column you can use Text(YourColumn, "dd/mm/yyyy") or whatever you want.

If this helps please mark as answered