Changing Date format on Gallery

(0) Share

Report

Posted on by Virikefe22

302

Hello,

I wish to change the date format in my gallery from the format originally captured from the SP list.

I wish to change it to this format below:

Any known solution???

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Virikefe22 ,
You can use the below formula in Text property of label used in Gallery -
Switch(Weekday(ThisItem.StartDate),1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5,"Thursday",6,"Friday",7,"Saturday","No day") & ", " & Text(ThisItem.StartDate,"mmmm dd, yyyy")
Assumptions -
StartDate is the column name
Virikefe22 302 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @NandiniBhagya20
The column name is Date. I implemented it like you suggested but all showing error. Meanwhile, the date is suppose to be the latest date on the SharePoint list.
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Virikefe22 ,
Can you please share the error message you are getting?
Where are you adding this formula, on which control - label, text input, etc.
Virikefe22 302 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your time @NandiniBhagya20
Now it's showing "No day" (see screenshot below)
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Virikefe22 ,
If you would like to display latest/last modified date or last created date, then you can use -
With({_date: First(Sort(SPListName,Created, Descending)).Created}, Switch(Weekday(_date),1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5,"Thursday",6,"Friday",7,"Saturday","No day") & ", " & Text(_date,"mmmm dd, yyyy"))
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

And remove the "no day" option from switch statement -
With({_date: First(Sort(Holidays,Created, Descending)).Created}, Switch(Weekday(_date),1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5,"Thursday",6,"Friday",7,"Saturday") & ", " & Text(_date,"mmmm dd, yyyy"))
Virikefe22 302 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @NandiniBhagya20
You're my Baymax