Manipulating times and dates

As mentioned earlier, dates and times are traditionally very tricky objects to work with. There are several functions available to help you use times and dates in your flows.

Calculating the day of the week

Let's say you want to use a Power Automate flow to determine what day of the week a particular date falls on. You can use the dayOfWeek() function to work this out:

1. Navigate to the Power Automate maker portal (https://make.powerautomate.com) and create a new Instant flow.
2. Click the Manually trigger a flow trigger on the canvas.

3. On the Parameters tab, click Add an input and select the Date input type.

   

   Figure 9.6 – Adding a date input type

4. Add an action.
5. Filter the actions for the Compose data operation action and add it to the canvas.

6. On the Parameters tab of the Compose action, in the...