Skip to main content

Notifications

Community site session details
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

 

  • 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

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 >