Skip to main content
Community site session details
Power Apps - Building Power Apps
Answered

how to convert date into day of week

Like (0) ShareShare
ReportReport
Posted on 21 May 2020 04:28:20 by

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

 

 

  • Verified answer
    v-xida-msft Profile Picture
    on 21 May 2020 at 08:18:36
    Re: how to convert date into day of week

    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,

  • Verified answer
    timl Profile Picture
    35,202 Super User 2025 Season 1 on 21 May 2020 at 09:42:15
    Re: how to convert date into day of week

    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")

     

     

    image.png

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Loading started
Loading started
Loading complete