cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MH3
Post Prodigy
Post Prodigy

Automatic Email Sent to User after 6 Months of Creation Date

Hi,

I have an application in which everyone creates Project information for a client Like this:
ProjectDet.png

Every user's email is recorded who ever creates a Project Record and they enter a Project Creation Date.

I want to automatically email that User after 6 Months of Project Creation Date (which is like 184 Days after the Project Creation Date) of that user.

I am confused if the user have 2 records which record will be sent in the email... I am stuck in creating the flow.

Any Help
FloweProject.png

 



Left Side Formula in Condition 

formatDateTime(item()?['ProjectCreationDate'], 'dd/MM/yyyy')


Right Side Formula in Condtion

formatDateTime(addDays(item()['ProjectCreationDate'], 184 ,'dd/MM/yyyy'))


Is there any mistake in the expression or Flow ?

1 ACCEPTED SOLUTION

Accepted Solutions
Nogueira1306
Resident Rockstar
Resident Rockstar

Ok. Then, instead of making a condition like this: 

 

DateDiff(Now(), Created)  equals 184

Set a condition like this:

 

DateDiff(Now(), Created) > 184


But if it is bigger than 184 it wil send every day. In day 185, 186, 187, 188, 189.....


View solution in original post

17 REPLIES 17
Nogueira1306
Resident Rockstar
Resident Rockstar

Hey! Why dont you use a DiffDate?

DateDiff( Created, Now() )   equals    184

 

 

Something like that

Hi @Nogueira1306 

The Problem is I want to send an email back to user after  6 months of project creation date.
and the user have multiple records. So, I want to email that whos 6 months are about to end  and with that record details..

My Flow is somehow not working 

Nogueira1306
Resident Rockstar
Resident Rockstar

Okay. Then your formula might be right. I thought that the problem was the  formula.

So. If you want to know that. It will only send the items in which the diff dates is 184

So, if a user has 1 item with 6 months and other with 5, it will only send the one with 6.

But I dont think yourformula is right. Because you are adding 184 fays to the day you created the record. That will never be the same...

Hi @Nogueira1306 

When I test the flow it runs but the expression is False. and hence it's not going into the Yes Block
Flow Ran.png

Is there any help you can do Please? it's urgent 😞

Nogueira1306
Resident Rockstar
Resident Rockstar

If it is false, it wont go to yes block...

Try getting an item that you know that created + 184 is today

@Nogueira1306 
Actually, there is no such item

But I had inputted 1 there and Tested the flow manually. it's still showing the same.

How can I fix this? 

Nogueira1306
Resident Rockstar
Resident Rockstar

Try with function DateDiff

 

Instead of utcNow(), you can try: Today() or Now()

DateDiff(Created; utcNow())             equals                  184

If you want to check the value of that DateDiff, out it in a var to check the value

Nogueira1306
Resident Rockstar
Resident Rockstar

Did you find the answer?

Hi @Nogueira1306 

Well I have created a Calculated Column of DateDifference

in Which I have Done (Today(), ProjectCreateDate) 

But, I am confused I want to email the user with the details of project whose Project Date is 6 months older or have past 184 days.

Seems like its still not working ;( 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (914)