web

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

News and Announcements icon

Power Platform CommunityForums Power Automate flow get this Monday

Power Automate

Answered

flow get this Monday

(1) Share

Report

Report

Posted on by Nick98765

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)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

sandeepstw 312 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

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

Was this reply helpful? Yes No

Join the conversation