Unanswered

DateTime Format List rows present in a table

(0) Share

Report

Posted on 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?

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

Hi @SIMIKE2016

Please follow the below steps.

The above expression I used is as follows:

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

Thanks

Was this reply helpful? Yes No
mmherdz 21 on at

Like (0)

Report

Hi - I tried your solution but it didn't work for me. I'm getting the below error
I'm not an IT person so I really don't understand it. I've been searching for the solution here. I wanted my date to be MM/dd/yyyy format and it's working in 'For a selected row' using the formatted value in dynamic content. But since I'm working on a lot of rows, I need to use "List rows present in a table". Really appreciate your help on this.

Thanks,
Mikee

Was this reply helpful? Yes No
Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (2)

Report
Based on your screen shown, @abm's expression needs to be modified to reference the current apply to each loop. Try the following:

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

Ellis

Was this reply helpful? Yes No
mmherdz 21 on at

Like (0)

Report

Hi Ellis - Thanks for your help. I'm still getting an error. 😞 Please see below:

Was this reply helpful? Yes No
Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (2)

Report
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

Was this reply helpful? Yes No
mmherdz 21 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (2)

Report

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

Ellis

Was this reply helpful? Yes No
mmherdz 21 on at

Like (0)

Report

Yes, that's right.

Was this reply helpful? Yes No
Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
mmherdz 21 on at

Like (0)

Report

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"

Was this reply helpful? Yes No