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?
Hi Ellis! You are right. I orginally used the expression because I thought that I should use "_" for spaces:
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
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:
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
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"
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
Yes, that's right.
Please confirm that the DateTime Format is set to ISO 8601:
Ellis
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.
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
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2