Dropdown Items property Date formatting issue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Scenario:

- Dropdown control

- Items property set to:

SortByColumns(
 AddColumns(
 Distinct(
 colAllRecords,
 PLN_STRT_DT
 ),
 "planStartDateFormatted",
 Text(Result, "[$-en-US]mm-dd-yyyy") //<---Formatting not being respected
 ), 
 "planStartDateFormatted", 
 Ascending
)

- Original PLN_STRT_DT is in ISO8601 datetime format ("2020-01-01T00:00:00Z")

- I'm trying to show a more user friendly format using ("01/01/2020")

- But the formatting is not being reflected in the Dropdown control

- Clearly seen here as well:

What am I missing?

Thank you

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@ericonline

Looks like it is seeing it as text.

Try the following:

SortByColumns( AddColumns( Distinct( colAllRecords, PLN_STRT_DT ), "planStartDateFormatted", Text(DateTimeValue(Result), "[$-en-US]mm-dd-yyyy") //<---Formatting not being respected ), "planStartDateFormatted", Ascending )

I hope this is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

That worked!

(Wrapping my head around this):

- So we converted the Text-type column to DateTimeValue, then back to Text.

- The interim step there allowed PowerApps to apply the formatting.

- Yeah, that makes sense to me.

- Another trick up the sleeve for future apps.

Thanks again!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@ericonline

Yep, you got it. Since the date was in ISO time, we needed to let PowerApps turn it into its date type, then we could format it with the standard text function.