Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Change date format in Dropdown List in Powerapps

Like (1) ShareShare
ReportReport
Posted on 13 Sep 2024 04:00:16 by 50
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:
  • Suggested answer
    CA1105 Profile Picture
    CA1105 222 on 13 Sep 2024 at 08:59:05
    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 Profile Picture
    FLMike 29,371 on 13 Sep 2024 at 04:51:07
    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.
     
     
    and in the New Column you can use Text(YourColumn, "dd/mm/yyyy") or whatever you want.
     
    If this helps please mark as answered 
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,238

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard
Loading started