Power Automate Excel list of rows Date format not ISO 8601

(1) Share

Report

Posted on by Wolfie82

Hi,

I have a flow which is working which will auto send email for Due Date within 30 days.

But when I replaced with the a different excel file. The date format is not ISO 8601 so the rest of my flow does not works.

Anyone could advise how to get the Due Date to become ISO 8601

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

trice602 16,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Wolfie82 ,

This should do it for you. Please mark as a solution and/or thumbs up! Always glad to help! Tom

Compose 1:
formatDateTime('12-30-1899', 'yyyy-MM-dd')

Compose 2:
formatDateTime(body('Add_to_time'),'yyyy-MM-ddTHH:mm:ss.0000000Z')

Was this reply helpful? Yes No
Wolfie82 22 on at

Like (1)

Report
Copy link

Link copied!

Hi @trice602

Thank you so much for your help. I have encounter error as there is some blank cell and '-'
in the Due date. How do I overcome this ?

Was this reply helpful? Yes No
trice602 16,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Wolfie82 ,

Please try and add a condition before add time. This will check for blanks and "-" and skip those rows. Please mark as a solution and give me a thumbs up if this works for you! Always glad to help! Tom

Was this reply helpful? Yes No
Wolfie82 22 on at

Like (0)

Report
Copy link

Link copied!

Hi @trice602
I have added a filter array steps after the Compose from Add to Time compose to filter those cell than are blank and '-' and Due Date within 90 days. It show BadRequest. The 'from' property value in the 'query' action inputs is of type 'String'.

The value must be an array. How can I change the date to array for the Expression to work ?

@if( not(or(equals(item()?['DueDate'],'-'),equals(item()?['DueDate'], ''))), less(item()?['DueDate'],formatDateTime(addDays(utcNow(),30),'yyyy-MM-dd')), false )

Was this reply helpful? Yes No