DateTime Format List rows present in a table

Like (0) Share

Report

Posted on 8 Jul 2021 14:26:16 by SIMIKE2016

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?

All responses (14)

Answers (0)

mmherdz 21 on 19 Apr 2022 at 22:20:59

Like (0)

Report

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 11,166 Super User 2025 Season 2 on 14 Apr 2022 at 19:53:10

Like (2)

Report

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 21 on 14 Apr 2022 at 19:26:45

Like (0)

Report

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:

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:
Ellis Karim 11,166 Super User 2025 Season 2 on 14 Apr 2022 at 17:24:00

Like (2)

Report

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:

Ellis
mmherdz 21 on 14 Apr 2022 at 17:18:20

Like (0)

Report

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:

In my flow, here's what I did:

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 11,166 Super User 2025 Season 2 on 14 Apr 2022 at 17:02:42

Like (2)

Report

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.

Example integer date 44609 converted to a Date in Excel:

Ellis
mmherdz 21 on 14 Apr 2022 at 16:51:31

Like (0)

Report

Re: DateTime Format List rows present in a table

Yes, that's right.
Ellis Karim 11,166 Super User 2025 Season 2 on 14 Apr 2022 at 16:44:57

Like (2)

Report

Re: DateTime Format List rows present in a table

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

Ellis
mmherdz 21 on 14 Apr 2022 at 16:29:45

Like (0)

Report

Re: DateTime Format List rows present in a table

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

I'm not sure why it is reading the date like that, as you can see here my dates are formatted as Dates.
Ellis Karim 11,166 Super User 2025 Season 2 on 14 Apr 2022 at 16:17:35

Like (2)

Report
Re: DateTime Format List rows present in a table

Your flow for needs to be constructed like this:

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