News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Power Automate Express...

Power Automate - Building Flows

Answered

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

Like (0) Share

Report

Report

Posted on 23 Jan 2024 05:14:23 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

All responses Img

All responses (2)

Answers Img

Answers (1)

knsrinath 527 on 24 Jan 2024 at 04:38:49

Like (0)

Report

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

Hi @v-yueyun-msft

Thank You!

Regards
Verified answer

v-yueyun-msft on 23 Jan 2024 at 05:42:42

Like (1)

Report
Re: Power Automate Expression, week start date and week end date for Today

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Leaderboard > Power Automate - Building Flows

#1

stampcoin 125

#2

David_MA 109 Super User 2025 Season 1

#3

Michael E. Gernaey 90 Super User 2025 Season 1

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans