I have an application in which everyone creates Project information for a client Like this:
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.
Left Side Formula in Condition
Right Side Formula in Condtion
formatDateTime(addDays(item()['ProjectCreationDate'], 184 ,'dd/MM/yyyy'))
Is there any mistake in the expression or Flow ?
Solved! Go to Solution.
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.....
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
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...
When I test the flow it runs but the expression is False. and hence it's not going into the Yes Block
Is there any help you can do Please? it's urgent 😞
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?
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
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 ;(
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.