cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NiugeS
Helper I
Helper I

List Rows Present in a table - Odata Filter - By dates 180 days from today

Hi all,

 

I have a spreadsheet in Sharepoint .  The flow will be triggered daily and I want it to send an email everytime it finds a date 180 days from today.  As the spreadsheet has 1000s of rows, i'm trying to apply a filter as per below.  

Test.jpg

The left hand of the filter has the following expression (today's date):

formatDateTime(addDays('1900-01-01',sub(int(item()?['Date']),2)),'yyyy-MM-dd')
 
and the right side has 
formatDateTime(addDays(utcnow(),180),'yyyy-MM-dd')
 
Unfortunately, I get an error message as follows:
"The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'"
 
Can someone advise what i'm doing wrong please?

Thank you
1 REPLY 1
Brad_Groux
Community Champion
Community Champion

Try utilizing utcNow. Further:

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,257)