web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Check that today is in...

Power Automate

Unanswered

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

(0) Share

Report

Report

Posted on by pmwhelan

377

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

P

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Ellis Karim 11,937 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation