cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
annetoal
Advocate III
Advocate III

Comparing two times

I am trying to write a condition that will take the next step if today's date is less than or equal to a date in SharePoint. The date in SharePoint is like

02/27/2021

The condition is 

ticks(items('Apply_to_each')?['Reviewdue'])is less than or equal to ticks(formatDateTime(utcNow()))

Flow is giving this error when it gets to the condition:

Unable to process template language expressions for action 'Condition' at line '1' and column '28281': 'The template language function 'ticks' expects its parameter to be a string that represents a timestamp. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#ticks for usage details.'.

Any help appreciated.

 

Thanks,

Anne

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @annetoal :

Could you tell me what Reviewdue's data type is?Is it a date and time column?
Could you show more details of your flow?

I've made a test for your reference:

1\My data souce:

1.JPG

Column (click to edit) Type
 Title Single line of text
TheDate Date and Time(Do not include time)

2\The flow

2.JPG

Expression Reference:

utcNow()

The Result:
10.gif

Best Regards,

Bof

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @annetoal :

Could you tell me what Reviewdue's data type is?Is it a date and time column?
Could you show more details of your flow?

I've made a test for your reference:

1\My data souce:

1.JPG

Column (click to edit) Type
 Title Single line of text
TheDate Date and Time(Do not include time)

2\The flow

2.JPG

Expression Reference:

utcNow()

The Result:
10.gif

Best Regards,

Bof

View solution in original post

.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (26,648)