Formatting Date pulled from Excel Array

[Barking_Mad1]

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.

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

[Sundeep_Malik]

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...