Add To Time Action in Power Automate

Introduction- In this blog we will understand the "Add to time" action of power automate/ cloud flow.

Explanation-
Add to time will add a integer number of a specified unit of time to the timestamp passed.
Example- We can add 1 day/ second/minute/year/month to the passed time stamp.

Syntax- addToTime('timestamp',interval,'timeUnit','dateFormat')
Date format is optional.


Output- 

Note- This action adds the mentioned value however it does not validate the output date. There is a possibility of the output being a non existent date time value.

Comments

Post a Comment

Popular posts from this blog

Retrieve Email Recipients (TO, CC, BCC) in Cloud Flow

Image
  Introduction: When we trigger a flow on Email Activity or retrieve email activity. However that does not provide us the recipient details of the email. Recipient details are stored as part of Activity  Party.    In this blog, we will understand how to retrieve the Email Recipients from the activity party of the email.   Solution: From Email messages you will get activity party. Reterive Activity Parties of that ID. Use Filter Array Action to get only the type of recipient you need. If you do not know the Partition type mask, you can check the output of List rows and read the formatted value. The Filter array output will you party type and party ID. In my case the party type was Users so I have used Party ID as input to get the User record.   Based on your party type and requirements, you can make use of the party id value which basically is your recipients 
Read more

The supplied reference link is invalid Error in Cloudflows

Image
  Introduction :  When we add a new row in dynamics CRM, we might end up using the lookup data reterived in previous action. There might be times when the previous record has returned a null. In such cases we get the error-    {    "error" : {      "code" :  "0x0" ,      "message" :  "The supplied reference link --  contacts () -- is invalid. Expecting a reference link of the form /entityset(key)."   } }     For this example; I was creating a new record and wanted to use the Account and its contact as lookup in my new record. The reterived Account did not have a contact and so my flow failed.   Solution :  Use the below if condition, if(empty(triggerOutputs()?['body/_primarycontactid_value']), ' ', concat('contacts(',triggerOutputs()?['body/_primarycontactid_value'],')'))   In this conditio...
Read more

Time Out and Retry Policy in Power Automate

Image
  Introduction :  While using Power Automate actions, you may need to retry or set timeout for your actions.   Solution : For Create, Update, Delete, Send HTTP request, Do Until Actions, simply go to Settings In Settings, you will find Timeout and Retry Policy options. Time Out: For the duration specified, the action will wait and then time out. Here P1D means 1day.  For minute- specify P1M and S for Seconds.   Retry: You can set the retry policy. There are 4 types: Default- The default is an exponential interval policy set to retry 4 times. None- Do not Retry Fixed Internal-  Count( No of times to retry), Interval( time between retry).   Exponential Interval-  Count(No of times to retry),  Interval(Time between retry) Minimum and Maximum Interval (the Retry will happen exponentially[Increase or decrease] between the specified intervals) Eg: If Interval is 1H and minimum Interval is set to 1M- it will decrease exponentially till it reaches 1M...
Read more