What Expression to use to offset a date from the created by value

[KeeganClarke]

Hello Everybody,

This should be an easy one for experienced users.

1. I am trying to apply a formula that if the "Title" column is null and the "Created by date" > one day it needs to send a reminder email to the user. 

I have tried multiple expressions for the "created by" value and not one of them work?

Am i inputting or using the wrong expression?

My Flow:

 Error Message from my condition:

Know this should be an easy fix, thank you for your help in advance!

[Pstork1 · Accepted solution]

Created By is the person who created the object, not the date when it was created.  You want the 'Created' dynamic content. That is the date when the item was created.

[KeeganClarke]

Hi Pstork1, thank you for pointing that out, I have changed it to created but the condition is coming out false,

All i want my condition to do is if the created date is greater than one day and the "containment value" is null send email to user to complete.  Please see my flow:

[Pstork1]

Make sure you check the null value first in the condition.  Also see if you can get the extra white space out of the blanks you are checking.  It may be miss firing because of that.  Otherwise your setup looks correct and should work.

[KeeganClarke]

thank you, i have made sure to check the blank value first. The condition is still returning false. When i run the condition to check the blank value only, it returns as true and the flow works. When i run it with "Created" > addDays(utcnow(),1) , maybe an issue with the expression in the created field?

[Pstork1]

Looking at this again, the problem is that the Creation Date will never be greater than now +1 day.  If you think about it you are comparing the date created to tomorrow.  If an item is created today it will never be greater than tomorrow.  I think what you want is Created is less than today -1.  An item created today would then test positive for that tomorrow.