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

(0) Share

Report

Posted on by 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!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Pstork1 69,383 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KeeganClarke 38 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Pstork1 69,383 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KeeganClarke 38 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Pstork1 69,383 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No