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:
Conclusion: In this way we can easily add days to current date in Power Automate flow.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.