Power Automate Fundamentals # 11: Usage of Add Days in Power Automate

Introduction:

In Power Automate, one of the common scenarios is to do some operations on current date. So, Add Days is one of the functions of its kind which works on the current date so that certain actions like sending an email to alert or give information to user as an example here I am adding 5 days.

Step 1:

Login to the required Power Apps environment using URL make.powerapps.com by providing user name and password and click on Flows on the left hand side as shown in the below figure.

Step 2:

After Step 1,  Click on New Flow and select instant cloud flow and provide the trigger as Manually trigger a flow and click on Create as shown in the below figure.

Step 3:

After Step 2, name the flow as AddDays and   click on + New Step and Choose Compose operation and provide the following

step name as Get UTC Date and Time now

Inputs : utcNow()

And click on ok/Update and save. Here this step extracts current UTC date and time   as shown in the below figure.

Step 4:

After Step 3, click on + New Step and Choose Compose Operation from actions and provide the following

step name as Add 5 Days and change to the American Format

and provide input as

 addDays(timestamp: string, days: integer, format?: string)

which expects 3 parameters time stamp as string and days in the form of integer and format as string and provide the input as below

addDays(outputs(‘Get_UTC_Date_and_Time_now’),5,’MM-dd-yyyy’)

And click on save as shown in the below figure.

Step 5:

After Step 4, Test and run the flow and see the desired result that 5 days are added to the current utc date time now as shown in the below figure.

Note:

  1. Make sure to save and run the flow whenever you try expressions.
  2. MS documentation is found at here
  3. This article focuses on adding days based on the current date , similarly addDays,addHours,addMinutes

Conclusion: In this way we can easily add days to current date in Power Automate flow.

One thought on “Power Automate Fundamentals # 11: Usage of Add Days in Power Automate

  1. Pingback: Rewind September 2021 – Common Man Tips for Power Platform, Dynamics CRM,Azure

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s