web

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

Power Platform CommunityForums Power Automate flow get this Monday

Power Automate

Unanswered

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 310 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (0)

Report
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.

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