cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Condition action, Created value is greater than (on a specific date)

Hi Folks,

I'm trying to send emails to specific users requesting data of certain items, these items must be created after July 1st 2020, however, I'm not sure what should be the correct condition to validate the creation date of the items.

Franvala22_1-1593813829123.png

 

Could you please help me to define what is the correct condition/comparison to validate if the creation date was July 1st or later?

 

Thanks in advance!

4 REPLIES 4
Highlighted
Super User
Super User

Re: Condition action, Created value is greater than (on a specific date)

Try something like in expression.

formatDateTime('2020-07-01T00:00:00', 'yyyy-MM-ddThh:mm:ssZ')

 

If this doesnt work try saving both the dates in a two different string variable and them compare strings.

 

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

 

Highlighted
Helper III
Helper III

Re: Condition action, Created value is greater than (on a specific date)

To be sure of using comparable formats, put the [created] field inside a FormatDateTime function with the same format string.

Note that you might need to convertTimeZone too depending on your environment settings.

 

 

Highlighted
New Member

Re: Condition action, Created value is greater than (on a specific date)

Hi

I will create a static date with 1 July 2020 and the condition will be if created date its greater then static date.

To do that you need to use date/time to convert created date and static date to something condition can read.

 

Highlighted
Super User III
Super User III

Re: Condition action, Created value is greater than (on a specific date)

@Franvala22 

Please see my screen shot below - that's all you need to do,  SharePoint stores data internally in yyyy-MM-dd format.  Watch out for time zone issues.

 

image.png

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,281)