Unanswered

Calculate days until salary day every day

(0) Share

Report

Posted on by AlexandruV

Hello

How do I create an automation in Power Automate to daily send the days remaining until payday, knowing that the payday is on the 11th of each month, and if this day falls on Saturday or Sunday, we will receive the salary earlier, i.e., on Friday. The remaining days should be sent on email to all colleagues and to TEAMS on a channel .

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AlexandruV ,
I did a test for your reference.
In my scenario:
int(utcNow('dd')) int(30) sub(outputs('Compose-Today'),outputs('Compose-SalaryDay')) parseDateTime(concat(split(formatDateTime(utcNow('yyyy-MM')),'-')[0],'-',split(formatDateTime(utcNow('yyyy-MM')),'-')[1],'-',outputs('Compose-SalaryDay')),'en-us','yyyy-MM-dd') dayOfWeek(outputs('Compose-formatSalaryDate'))
outputs('Compose-DateDiffer') int(-2) outputs('Compose-dayOfWeek') mul(outputs('Compose-DateDiffer'),-1)
outputs('Compose-dayOfWeek') addDays(outputs('Compose-formatSalaryDate'), -2, 'yyyy-MM-dd') utcNow('yyyy-MM-dd') mul(outputs('Compose-DateDiffer'), -1)
outputs('Compose-DateDiffer') int(-1) dayOfWeek(utcNow()) outputs('Compose-dayOfWeek')
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
AlexandruV 4 on at

Like (0)

Report
Copy link

Link copied!

Hello

Thanks, it's looks ok. I will try now.
But I didn't saw condition 1

Was this reply helpful? Yes No
AlexandruV 4 on at

Like (0)

Report
Copy link

Link copied!

Hello
not working , but in my opinion should be more easy
like today date minus salary date. I'm new in automation

Was this reply helpful? Yes No