Answered

Add/subtract days to date and set format

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm trying subtract one day from current time and call it sat with the format dd mmm yy, and add 5 days to current time and call it sun also with the format dd mmm yy, I've tried using the add days action as well as the compose action but when I add the results to the email subject all I get is

(Week of formatDateTime(triggerBody()?['2022-08-16T17:34:48.8377812Z'],'dd/MM/yyyy')+5 - 2022-08-16T17:34:48.8377812Z )

so the sunday is displayed

2022-08-16T17:34:48.8377812Z'],'dd/MM/yyyy')+5.

is my syntax of, is there a better (proper) way to do this?

Any help would be greatly appreciated.

Derek

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sundeep_Malik 6,499 on at

Like (0)

Report
Copy link

Link copied!

Hey @Anonymous ,
For these date type of problems in Power Automate, I use the tick method. Its pretty helpful.
You can see how it works in the following post:

How to find the number of days between two dates u... - Power Platform Community (microsoft.com)

Fantastic solution for these date problems by @ScottShearer

I hope this reply will help you. If you have any doubts please reply.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @Sundeep_Malik

I looked at the link you provided, but I seem to have run into an issue. as per the images below, the flow does not seem to like Current time being converted into ticks;
I receive this error;
I don't want to find the difference between the two dates,

I just want to subtract 1 day from current date to create a date that I will call Sunday and then
Add 5 days to current date and call it Saturday and use both dates in a subject line of an email.

Cheers!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

I was able to resolve this allot easier that I allowed myself to realize . . .

I simple created 2 compose actions

Saturday, expression set to formatDateTime(addDays(utcNow(), +5), 'MMM dd yyyy')

and Sunday, set to formatDateTime(addDays(utcNow(), -1), 'MMM dd yyyy')

done.

Was this reply helpful? Yes No