web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / 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) ShareShare
ReportReport
Posted on by 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 ...

pmwhelan_0-1677262805491.png

 

pmwhelan_1-1677262838291.png

 

 

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

 

pmwhelan_2-1677263054652.png

 

 

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)
  • Ellis Karim Profile Picture
    11,681 Super User 2025 Season 2 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard