cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Barking_Mad1
Helper II
Helper II

Formatting Date pulled from Excel Array

Hi,

 

I have a flow to send an email (or emails) when today's date is equal to that of the date (or dates) in an Excel column. I can then generate an email to send as a reminder, which works fine. The only problem I have is that the dynamic field pulls the date I want  to use into the email from Excel as numbers (44943) rather than the format: dd-MMM-yy.  I've tried to use a datetimeformat , but because it's an array it throws an error. Can anyone help?

 

Note: The date I want to drop into the email is in a different column to the 'ReminderDate' date I check in the filter query as below.

 

Barking_Mad1_0-1666193105736.png

 

formatDateTime(utcNow(),'dd-MMM-yy')

 

Barking_Mad1_2-1666193580635.png

 

 

 

1 REPLY 1
Sundeep_Malik
Community Champion
Community Champion

Hey @Barking_Mad1 

Unfortunately you will not be able to do it this way.

You will have to write a condition for this and format the date in correct way.

Check out the post for formatting the date coming from excel.

https://powerusers.microsoft.com/t5/General-Power-Automate/The-datetime-string-must-match-ISO8601-fo...

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,623)