News and Announcements icon

Power Platform CommunityForums Power Automate - Using Connectors To Trigger an email 3 ...

Power Automate - Using Connectors

Answered

To Trigger an email 3 days before due date.

(0) Share

Report

Report

Posted on by gunti

28

how to write an expression to get an email 3 days before due date.

The date is from excel sheet column named DueDate.

The date format in excel sheet is mm/dd/yyyy.

All responses Img

All responses (2)

Answers Img

Answers (1)

gunti 28 on at

Like (0)

Report

Re: To Trigger an email 3 days before due date.

quick question: is it ok if we keep the format 'yyyy-MM-dd' while writing the expression. Because the date format in excel column is in 'MM/dd/yyyy'
Verified answer

v-xiaochen-msft on at

Like (0)

Report

Re: To Trigger an email 3 days before due date.

Hi @gunti ,

Please try this

formatDateTime(item()?['DueDate'],'yyyy-MM-dd')

formatDateTime(addDays(utcNow(),3),'yyyy-MM-dd')

item()?['Mail']

Best Regards,

Wearsky

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans