cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ReyOrtiz
Helper II
Helper II

Adding Dates

Hi All

I working on a project, and I need to create a flow that will take the date on a column and add the requested time; for example, if the date is 8/3/22 and I need the Monday in 2 weeks from the date, this will reflect into a Calendar.

I appreciate the help.

1 ACCEPTED SOLUTION

Accepted Solutions
Rhiassuring
Super User
Super User

Hi there, 

 

You can use the addDays functionality. 

Create a Compose action. Click on Expression. Type in "addDays()". In the brackets, point to the Dynamic Content that holds your date (for example, an output from SharePoint). Then, type a comma, and the amount of days you want to add - ie, 14 for 2 weeks.

 

ie, addDays(FIELD,2)

EDIT: Sorry I just noticed the Monday part. Would it be the Monday following the 2 week mark? Or the closest Monday to the 2 week mark?

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



View solution in original post

2 REPLIES 2
Rhiassuring
Super User
Super User

Hi there, 

 

You can use the addDays functionality. 

Create a Compose action. Click on Expression. Type in "addDays()". In the brackets, point to the Dynamic Content that holds your date (for example, an output from SharePoint). Then, type a comma, and the amount of days you want to add - ie, 14 for 2 weeks.

 

ie, addDays(FIELD,2)

EDIT: Sorry I just noticed the Monday part. Would it be the Monday following the 2 week mark? Or the closest Monday to the 2 week mark?

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



That worked, and it made it easier to write an expression from scratch; I like that shortcut, thank you

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,661)