web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Week ending dates

Power Automate

Answered

Week ending dates

(1) Share

Report

Report

Posted on by lee_baldwin

7

I have created a recorded script that is working properly. The main issue I am having is that I have a couple of points in the run that a date needs to be input. That date is determined on whether the flow is being run on Monday or Tues - Friday. If it is on Monday, then it should use the previous Sunday date (04/22 would use 04/21), but the other 4 days of the week would use the next Sunday date (04/24 would use 04/28). I am new to Power Automate, so I am not sure how to get it to do this.

Thank you for any help.

Categories:

Power Automate Desktop

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

trice602 16,679 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lee_baldwin ,

I think there are a ton of ways to do this and I will show you one that is functional and easy to understand. So here I am getting the current date (run time) and then getting the "DOW" as Wednesday (example).

Next I create a handful of cases, if = Monday, get current date - 1 to get the desired previous Sunday, else in each other case, I am adding days to the current date to get the next Sunday date, adding a different number of days for each DOW.

In my example, since today is Wednesday, if gets next Sunday's date 4/28/2024. Again, functional and easy to understand recognizing there are lots of ways to achieve the same result, others may even be more efficient.
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @lee_baldwin

Another approach you can try is like below

Here i am using if else condition which checks whether date is monday or not, if monday , it takes previous day's date else it will run a .net script which calculates the next sunday for other days.

refer the below code for more details

DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateOnly CurrentDateTime=> CurrentDate Text.ConvertDateTimeToText.FromDateTime DateTime: CurrentDate StandardFormat: Text.WellKnownDateTimeFormat.ShortDate Result=> DateTextFormat Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDate CustomFormat: $'''dddd''' Result=> Day IF Day = $'''Monday''' THEN DateTime.Add DateTime: CurrentDate TimeToAdd: -1 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> ResultedDate Text.ConvertDateTimeToText.FromDateTime DateTime: ResultedDate StandardFormat: Text.WellKnownDateTimeFormat.ShortDate Result=> ResultedDate ELSE Scripting.RunDotNetScript Language: System.DotNetActionLanguageType.VisualBasic Script: $'''DayOfWeek= Cint(CDate(InputDate).DayOfWeek) NextSundayDate= CDate(InputDate).AddDays(7).AddDays(-DayOfWeek).ToString(\"dd-MM-yyyy\")''' @'name:InputDate': DateTextFormat @'type:InputDate': $'''String''' @'direction:InputDate': $'''In''' @'name:DayOfWeek': $'''''' @'type:DayOfWeek': $'''Int''' @'direction:DayOfWeek': $'''Out''' @'name:NextSundayDate': $'''''' @'type:NextSundayDate': $'''String''' @'direction:NextSundayDate': $'''Out''' @DayOfWeek=> DayOfWeek @NextSundayDate=> ResultedDate END

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Join the conversation