how to convert date into day of week

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Does anyone know how i can turn date & time into day of week?

I am using Gallery to show my records and I have create date show in one of the fields i.e. 19/5/2020

Can I have another field that shows TUES?

Database: SharePoint

Screen Shot 2020-05-21 at 11.24.55 AM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

sayyed007amir 357 on at

Like (5)

Report
Copy link

Link copied!
Using this code you can easily convert:

Switch(Weekday(DateColumnName) ,1,"SUN",2,"MON",3,"TUE",4,"WED",5,"THURS",6,"FRI",7,"SAT")

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

where do I put this code? Thank you

Was this reply helpful? Yes No
sayyed007amir 357 on at

Like (1)

Report
Copy link

Link copied!

Text Property of Label.
Or where ever you want to show

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to display weekday of the corresponding date time value within your Gallery?

Based on the needs that you mentioned, I agree with @sayyed007amir 's thought almost. The Weekday() function could achieve your needs.

Please consider add a Label inside your Gallery, set the Text property of this Label to following:

Switch( Weekday(ThisItem.Start), 1, "SUN", 2, "MON", 3, "TUE", 4, "WED", 5, "THU", 6, "FRI", 7, "SAT" )

Note: The Start represents the Start Date time type column in your SP List, please replace it with actual column name

Weekday function

Please take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Verified answer

timl 36,774 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
Hi @Anonymous

You can just add a label and call the Text function to apply a format that displays the day. This would be easier than calling the Weekday function and writing a Switch statement.

Text(ThisItem.Created, "ddd")

Was this reply helpful? Yes No