How do I add days to a partial date such as 07-Feb using Power Automate?

Question: I am being presented with a date as text such as “07-Feb”. I just need to be able to add 6 days to it. I have tried a bunch of ways to make this work to no avail. Any recommendations?

Power Automate has an addDays function but we will need to provide the date string in a valid timestamp format.

What we need to do is:

  • Add the current YEAR to the date string to get 07-Feb-2022
  • Add 6 days
  • Format the output of the addDays() function as dd-MMM to get 13-Feb

The expression we can use to achieve this is:

addDays(concat(variables('varDate'),'-', utcNow('yyyy')),6,'dd-MMM')
The addDays expression for the flow.

This is the flow:

The demo flow.

And here is the runtime output:

The runtime output

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 )

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Built with WordPress.com.

Up ↑

%d bloggers like this: