Problem statement:
While building automations, there arises a need to generate various date outputs based on performing date calculations and date operations.
For example, generate a report on the first day of the next month.
OR Select a date 2 weeks from the DatePicker date on website.
All of these require logic to build.
There are no direct format functions available to generate these Date outputs.
How to get such kind of Date outputs using Power Automate Desktop?
- Last date and day name of current month
- First date and day name of current month
- Get day number of week from given date (Choose your own first day of week or use system default)
- Get the date that is x weeks prior from given date
- Convert any date like August 1st, 2023 to a format like 01-08-2023 (no direct format function available)
- Get the day number of the year from a given date
- Find the week number of the year from given date (Choose your own first day of week or use system default)
- First date and day name of the year from a given date
- Last date and day name of the year from a given date
- First date and day name of next month
- Last date and day name of next month
- Refer Desktop Flow attached.
- Built on version 2.31
- You need to have the 'Regions' action which was introduced in 2.29
- Refer the comments in the Flow and add inputs wherever mentioned.
- How to Copy-Paste the raw code from the given text file:
