Skip to main content

Notifications

Community site session details

Community site session details

Session Id : DAIIebeTjUDm1zceZMtKl4
Power Automate - Building Flows
Answered

Formatting the date coming from Get Items

Like (0) ShareShare
ReportReport
Posted on 25 May 2022 13:55:05 by 13

I am using Get Items to grab some rows from a Sharepoint list, then want to summarise these in a table to email out once per day. I have got this working, but am having some issues formatting the dates in the table. I have attempted the below solution, with an array, but I just get the whole array in every row of the table. Any suggestions on how I can format the dates?

CReay_0-1653486730434.png

CReay_1-1653486765478.png

 

  • CReay Profile Picture
    13 on 25 May 2022 at 14:29:53
    Re: Formatting the date coming from Get Items

    Thanks. I tried this first, but was getting an error returned. It seems to work now, so clearly I had a small issue somewhere.

  • Verified answer
    Expiscornovus Profile Picture
    31,732 Most Valuable Professional on 25 May 2022 at 14:25:31
    Re: Formatting the date coming from Get Items

    Hi @CReay,

     

    If you want apply formatting to an item in a select you can actually use an expression directly in the value field of that key.

     

    Below is an example of that approach.

    I have used this expression for my Date and Time value field:

     

    formatDateTime(item()?['DateandTime'], 'yyyy-MM-dd')

     

     

    formattinginselect.png

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

Announcing the Engage with the Community forum!

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 368 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 300 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 299

Overall leaderboard
Loading started