startOfMonth function(Power Automate Cloud flows)
Retrieves the first day of the month at the specified date and time.
Spec
startOfMonth('<timestamp>','<format>')
| Argument | Default | Description |
|---|---|---|
| timestamp | Required field | Specifies the date and time of the conversion source. Any format other than "yyyy-MM-ddTHH:mm:ss.ffffffffK" will result in an error. |
| format | yyyy-MM-ddTHH:mm:ss.ffffffffK | Specifies the format of the result. If not specified, the format is "yyyy-MM-ddTHH:mm:ss.ffffffffK" as well as "timestamp". |
How to use
In most cases, it is used in the "value" when initializing or setting variables of type "string".
Click on the "Expression" tab, startOfMonth, 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.
If you want to change the format of the result, specify the format in the second argument.
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.