cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Use Today date parameter

I would like to have a condition in my Flow that upon a creation of a new item, checks to see if a date field in SharePoint online is equal to today's date, if so perform an action.  Is this possible to do?  I don't see an option to do this.

7 REPLIES 7
Highlighted
Power Apps
Power Apps

Re: Use Today date parameter

This is achievable if you create a condition and flip it to advanced mode. In the advanced mode, you can use the same expression syntax that Logic Apps uses. Expression reference is here: https://msdn.microsoft.com/en-us/library/azure/mt643789.aspx

 

From there, you may have to get a bit crafty. It looks like the dates that come back for sharepoint items are in this format: 2016-05-06T21:43:02Z

 

So, start by using the editor to do a basic comparison with the timestamp field, then switch to the advanced view. This will tell you how to reference the field you care about in the expression. I chose to use the 'Created' time when testing this.

 

Then, to do the actual comparison, we can trim just the date part from the timestamp, and compare it against a custom-formatted utcnow expression. So putting this into the advanced condition did the trick for me: @equals(substring(triggerBody()['Created'], 0, 10),utcnow('yyyy-MM-dd'))

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Use Today date parameter

This worked for me! But now I get all users from salesforce with today's date as close oppr. date now I can not send an email to those users, it gives array error. I want to send email to these users via flow.

Highlighted
Anonymous
Not applicable

Re: Use Today date parameter

Does this really mean: there is nothing such as a today() function letting me compare a field date easily, without having to care about calendar date display settings?

I would like to have one of the easiest thinkable flows: a notification triggered by a date property out of a sharepoint list. Isn't that possible?

Highlighted
New Member

Re: Use Today date parameter

Hi Samuel,

 

I'm trying to achieve a similar flow where an email is triggered when a date is matched on a SharePoint list item. I've tried to follow your instructions below but get lost around the (substring(triggerBody)) part. I haven't been using flow for long but would you mind giving some further instructions on how to set up what you've desribed below?

 

thanks,

 

Highlighted
Frequent Visitor

Re: Use Today date parameter

Good day,

 

Thanks for this - it worked.

 

Take note: your Column Name should not contain a space (ex. reminder date) it should have no spaces ex. ReminderDate.

 

many thanks again

 

Charmaine

Highlighted
Anonymous
Not applicable

Re: Use Today date parameter

I am very new to flows. I cannot get this function to work for me. Any help would be appreciated! 

Highlighted
Frequent Visitor

Re: Use Today date parameter

good day,

 

This is what i used to get the date as todays date 

 

todaysdate.png

 

and i used this original description

 

https://www.youtube.com/watch?v=-klsQ4LrG6E

 

hope this helps

 

regards

 

 

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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 (7,142)