web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Power Automate Express...

Power Automate

Answered

Power Automate Expression, week start date and week end date for Today

(0) Share

Report

Report

Posted on by knsrinath

527

Hi

Request a Power Automate Expression, week start date and week end date for Today

Ex : India Time Zone

Today = 23-01-2024

Week start Date = 22-01-2024 (Monday)

Week End Date =28-01-2024 (Sunday)

Thanks & Regards

Categories:

I have the same question (3)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi , @knsrinath
You can use this code to get the Monday:

if(equals( dayOfWeek(utcNow()) ,0) , addDays(utcNow(),-6) , addDays(utcNow(), sub(0, sub(dayOfWeek(utcNow()),1)) ) )

You can use this code to get the Sunday:

addDays( if(equals( dayOfWeek(utcNow()) ,0) , addDays(utcNow(),-6) , addDays(utcNow(), sub(0, sub(dayOfWeek(utcNow()),1)) ) ) , 6)

The result is as follows:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
knsrinath 527 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft

Thank You!

Regards

Was this reply helpful? Yes No

Join the conversation