Generate Reminder Email in Excel and Power Automate

Thank you again.

In list rows, I did have the ISO 8601 selected.

I used the same expression that you had in your screen shot for my flow:

When I looked at the Raw Inputs (similar to your last screen shot), I see the following (I removed certain columns):

[ {"@odata.etag": "","ItemInternalId": "***","Branch Name": "***","Reminder Date": "2024-11-15T00:00:00.000Z","INSTALL DATE": "2024-11-22T00:00:00.000Z","CLOSEOUT  DATE": "2025-02-28T00:00:00.000Z", },

]

Dear Brian,

May I know whether you select ISO 8601 in the "List rows in Excel" action? If no, I suggest you try it to see and let us know the result.

I adjust the cell format and keep the same format as you in your example and did a test and the Filter Array part works fine.

Could you check whether the output of the List rows in Excel table action shows the correct time format in your flow? Some related screenshots are appreciated.

Note: Remove any private information before uploading the screenshots.

Your efforts and time are greatly appreciated!

Sincerely

Cliff | Microsoft Community Moderator

Thank you again for the assistance on this.

I tried following the instructions you had sent. My flow is failing at the "Filter Array" step with the error below.

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(formatDateTime(item()?['Reminder Date'], 'yyyy-MM-dd'), formatDateTime(utcNow(), 'yyyy-MM-dd'))' failed: 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.

I tried keeping my dates from my excel file in the format you sent in the screenshot and still got the above error.

I attempted to change the filter array to:

formatDateTime(item()?['Reminder Date'],'yyyy-MM-dd') is equal to formatDateTime(utcNow(),'yyyy-MM-dd')

Dear Brian,

You need to embed HTML table in the email body.

Here is an example for your reference.

Select:

Map:

{

"BranchName": @{item()?['Branch Name']},

"SO": @{item()?['SO']},

"ReminderDate": @{formatdatetime(item()?['Reminder Date'],'MM/dd/yyyy')},

"InstallDate": @{formatdatetime(item()?['Install Date'],'MM/dd/yyyy')},

"CloseoutDate": @{formatdatetime(item()?['Closeout Date'],'MM/dd/yyyy')}

}

Result:

Welcome to share any update at your convenience.

Your efforts and time are greatly appreciated!

Sincerely

Cliff | Microsoft Community Moderator

Here is a screen shot of the email I am currently receiving: