Check that today is in between two dates when looking at rows in a SharePoint list?

(0) Share

Report

Posted on by pmwhelan

375

I have a SharePoint list called Relationships with two Date columns

Start and End

Also two columns Parent and Child

I want to loop through the list and send an email when "Parent = Child" but also if todays date is between the Start and the End

I set the current date ...

It seems to loop through and doesn't find an matches even though all rows have

Also I get the error below if the Start or End is empty for any row ...

Unable to process template language expressions for action 'Condition_2' at line '0' and column '0': 'The template language function 'lessOrEquals' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

How do I check for empty

Thanks

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
Hi @pmwhelan ,

UtcNow() will return the current date and time, for example:

2023-02-24T18:34:25.0950285Z

For current date please try:

utcNow('yyyy-MM-dd')

Dates are stored in SharePoint are as yyyy-MM-dd along a time component. Your site will display the date according to the site's region settings.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No