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

🌸You're Invited: Community Spring Festival Awards Celebration 🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,743 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,079 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans