ticks function(Power Automate Cloud flows)
Obtains the elapsed time since January 1, 0001 for the given date and time.
The unit is 100 nanoseconds.
It has few uses, but may be used for date serial calculations in Excel.
Spec
ticks('<timestamp>')
| Argument | Default | Description |
|---|---|---|
| timestamp | Required field | Specifies the date and time of the conversion source. |
How to use
In most cases, it is used in the "value" when initializing or setting variables of type "Integer".
Click on the "Expression" tab, ticks, and the function name and () will be set in the expression field.
Specify the date of the extraction source as an argument.
If you want to use dynamic content or variables, the ,delimiter is the same.
(How to get dynamic content with expressions.)
Click on the OK button, and if the display looks like the following, the setting is complete.
You can change the function by clicking this purple icon.
For example, the serial for May 15, 2022 is calculated as follows.
add(div(sub(ticks('2022-05-15'),ticks(‘1900-1-1’)),864000000000),2)
For those who want to learn Power Automate Cloud flow effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Cloud flow to streamline your workflow.