Exercise - Use JavaScript to find the last day of the current month

Completed

In this exercise, you create a flow that calculates the last day of the current month by using JavaScript code.

1. Launch the Power Automate desktop app console and create a new flow named Last day of the month.

   

2. Under Actions, search for get current. Then select Get current date and time.

   

3. Use a Get current date and time action to store the current date in a datetime variable.

   

4. The next actions include variables. Expand Variables and double-click Set variable.

   

5. Double-click the default NewVar and change it to Month.

   

6. Next, select {x}. Under Flow variables, CurrentDateTime select .Month. Select Select.

   

7. Follow the same steps to add the Year variable as well.

   

   

8. Search for run java under Actions and double-click Run JavaScript.

   

9. In the JavaScript to run box, type var month =, select {x}, select %Month%, and then select the Select button. Add ;.

   

   

10. In a new line, type var d = new Date(, select {x}, select %Year%, and then select the Select button. Add , month);.

11. In a new line, type WScript.Echo(d);.

    

    Next, select the Variables produced option and toggle on ScriptError. Then select Save.

    

12. Search for the Parse text action in the workspace and use the presented regular expression to remove the date's unnecessary parts.

    

13. Use a Convert text to datetime action to convert the parsed text into a datetime variable.

    

14. Use the Convert datetime to text action to convert the datetime value back to text. Deploy this action to create a custom format for the date.

    

15. Use a Display message action to show the final text variable that contains the last day of the month.

    

16. Save the flow and then run it. Try different time zones to make sure the flow can handle all possible scenarios.