cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alejandra1
Frequent Visitor

Schedule email

Hello, 

 

I try to send an email one day before of an specific date that I take from the answer of a form. So first I "substract from time" so it calculate the day when the email should be sent:

alejandra1_0-1626428170333.png

And then I use "delay until" in which I put the data from the the step before. When I run the flow it fail and what I receive is this message: 

alejandra1_1-1626428325229.png

Can anyone help me ? 

Thank you. 

5 REPLIES 5
eric-cheng
Solution Sage
Solution Sage

Hi @alejandra1 ,

 

Try pasting the following into the Delay Until as an expression.  Please replace the date with your own.

 

formatDateTime('2021-07-17T00:00:00','yyyy-MM-dd HH:mm:ssZ')
 
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Hello, 

 

I can't replace the date with my own because the scheduling date email sending depends on the date choosen by the person who makes the form. 

Hi @alejandra1 ,

 

You can simply pass the date from the form

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Hello again, 

 

The issue is I want automatically send the email the day before of the date that this person choose on the form. 

 

Hi @alejandra1 ,

 

You can use addDays with a -1

 

addDays(formatDateTime('2021-07-17T00:00:00','yyyy-MM-dd HH:mm:ssZ'),-1)

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

 

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,439)