web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

flow get this Monday

(1) ShareShare
ReportReport
Posted on by 62

hi everyone I want to get my date for this Monday, can someone help me?

For example, it's 3/7/2024 and I want to get 3/4/2024.

If it's 3/3/2024, I want to get 2/26/2024

Categories:
I have the same question (0)
  • Verified answer
    sandeepstw Profile Picture
    310 Moderator on at
    Re: flow get this Monday

    Hi @Nick98765 ,

     

    Use this expression in Power Automate- 

     

    'addDays(variables('YouInputDate'), -mod(dayOfWeek(variables('YouInputDate'), 1) - 2, 7))'

     

    Replace 'YouInputDate' with the input date value. 

     

    If this helps you, please give kudos and mark it as a solution. 

    Thanks, 

    Sandeep Mishra 

  • Verified answer
    v-yetonggu-msft Profile Picture
    on at
    Re: flow get this Monday

    Hi @Nick98765 ,

    I tested the expression provided by @sandeepstw , and flow told me that the expression was invalid, so I was confused.

    I used my method to test and found that I could also get Monday’s date.

    vyetonggumsft_0-1709804219692.png

    vyetonggumsft_1-1709804250682.png

    if(equals(dayOfWeek(outputs('Date')),0),addDays(outputs('Date'),-6,'yyyy-MM-dd')
    ,addDays(outputs('Date'),mul(sub(mod(dayOfWeek(outputs('Date')),7),1),-1),'yyyy-MM-dd'))

    Best Regards,

    Sunshine Gu

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard