web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 3HqRKpv6eVs8gT+hgkGnki
Power Automate - Building Flows
Unanswered

DateTime Format List rows present in a table

Like (0) ShareShare
ReportReport
Posted on 8 Jul 2021 14:26:16 by 13

Hello

I am using the List Rows Present in a Table function and want to use the DateTime format field so the date displays correctly later on in my flow. The options ISO8601 and Serial Number are given. I just want the format to be mm/dd/yyyy. 

 

Any ideas? 

  • mmherdz Profile Picture
    21 on 19 Apr 2022 at 22:20:59
    Re: DateTime Format List rows present in a table

    Hi Ellis! You are right. I orginally used the expression because I thought that I should use "_" for spaces:

    formatDateTime(items('Apply_to_each_4')?['Due_date'],'MM-dd-yyyy')
     
    Then it worked now when I changed it to 
    formatDateTime(items('Apply_to_each_4')?['Due date'],'MM-dd-yyyy')
     
     
    Thank you so much for your help on this. You were really a great help! I hope you have a nice and blessed day! ^^
  • Ellis Karim Profile Picture
    11,166 Super User 2025 Season 2 on 14 Apr 2022 at 19:53:10
    Re: DateTime Format List rows present in a table

    The error message is complaining that it has tried to convert a date using the formatDateTime() function, but the date supplied was empty.

     

    Can you share the expression you are using for the Compose 2 action please?

    Please share the sample data and please check that the cell contains data and that the expression references the correct column name.

     

    Ellis

     

     

  • mmherdz Profile Picture
    21 on 14 Apr 2022 at 19:26:45
    Re: DateTime Format List rows present in a table

    Hi Ellis - Thank you so much!!! It worked now 🙂 

    Can I please get one more help? I'd like to add one more date which is the due date. In my excel file, I have a column for due date which is a formula adding 2 days from the date column:

    mmherdz_1-1649964100987.png

     

    So what I did is created another compose and formatted the due date. Then in my 'send an email' I added the dynamic content from the output of Compose 2 but in ended in error:

     

    mmherdz_0-1649964086151.png

     

  • Ellis Karim Profile Picture
    11,166 Super User 2025 Season 2 on 14 Apr 2022 at 17:24:00
    Re: DateTime Format List rows present in a table

    The expression in the compose action converts the date and stores the result the compose action. The original date in Excel is unchanged. You need to include the Compose dynamic content in the email:

    Snag_b267c0.png

     

    Ellis

  • mmherdz Profile Picture
    21 on 14 Apr 2022 at 17:18:20
    Re: DateTime Format List rows present in a table

    Hi - I just tried it and I dont have any errors in my flow anymore. However, in the output email, it seems that the formatting didn't work. I really appreciate your help and I'm sorry if took too much of your time.

    This is how it looked like in the email it sent out:

    mmherdz_0-1649956666031.png

     


    In my flow, here's what I did: 

    mmherdz_1-1649956686280.png

     


    Was there something wrong with the expression? 

    formatDateTime(items('Apply_to_each_4')?['Date'],'MM-dd-yyyy')
    I used 'Date' in the expression because I wanted to  apply it in the dynamic content / column "Date"

  • Ellis Karim Profile Picture
    11,166 Super User 2025 Season 2 on 14 Apr 2022 at 17:02:42
    Re: DateTime Format List rows present in a table

    Excel stores dates as integer values eg. 44609.

    The flow is still reading the dates as integer values instead of ISO 8601 dates. Please try setting the column to Date in the Excel file then save.

     

    2022-04-14_17-56-17.gif

     

    Example integer date 44609 converted to a Date in Excel:

    2022-04-14_18-00-54.gif

     

    Ellis

  • mmherdz Profile Picture
    21 on 14 Apr 2022 at 16:51:31
    Re: DateTime Format List rows present in a table

    Yes, that's right.

    mmherdz_0-1649955085853.png

     

  • Ellis Karim Profile Picture
    11,166 Super User 2025 Season 2 on 14 Apr 2022 at 16:44:57
    Re: DateTime Format List rows present in a table

    Please confirm that the DateTime Format is set to ISO 8601:

    Snag_8f68b5.png

     

    Ellis

  • mmherdz Profile Picture
    21 on 14 Apr 2022 at 16:29:45
    Re: DateTime Format List rows present in a table

    Hi, I just tried it again but I'm getting the below error.

    mmherdz_1-1649953774875.png

     

    I'm not sure why it is reading the date like that, as you can see here my dates are formatted as Dates.

    mmherdz_0-1649953716347.png

     

  • Ellis Karim Profile Picture
    11,166 Super User 2025 Season 2 on 14 Apr 2022 at 16:17:35
    Re: DateTime Format List rows present in a table

    Your flow for needs to be constructed like this:

    ekarim2020_0-1649952770702.png

    with the expression in the Compose action:

    formatDateTime(items('Apply_to_each_4')?['DateOfBirth'],'MM-dd-yyyy')

     

    Please try the above and report back. See @abm 's solution below for reference.

     

    Ellis

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 our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

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!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete