Answered

Automatically Send Email to Users 30 days prior to date

Like (0) Share

Report

Posted on 8 Aug 2022 07:36:19 by Community Power Pla...

Dear Community,

I am currently trying on working on a Power Automate Flow to automatically send an E-Mail to our workers (responsible intern) when a certain bill is due in 30 days. So if "Date Column"-30=today as a trigger.

Date	Responsible intern	Amount	Project
07.09.2022	email1@emailending.com	23023	ABC
13.09.2022	email2@emailending.com	122	EFG
21.09.2022	email1@emailending.com	4674	HIJ

Then the Email should read something like

"Dear Worker, your project <project> has a bill of <amount> due in 30 days."

Do you guys have any ideas how to do this in Power Automate? Is this possible in Power Automate?

Thanks for your help!

Kind regards,

Janik

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-bofeng-msft on 09 Aug 2022 at 06:49:47

Like (1)

Report
Re: Automatically Send Email to Users 30 days prior to date

Hi @Anonymous ,

Firstly , if there are more than 256 rows in your excel table you need to trun on the Pagination function and set it to 5000, otherwise the 'list rows' action will only return 256 rows.

Secondly, you could add a filter action to filter the array return by the 'list rows' action, I've made a test for your reference:

@equals(startOfDay(item()?['Date']), startOfDay(addDays(utcNow(), 30)))
items('Apply_to_each')['Responsible intern']

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 08 Aug 2022 at 11:01:54

Like (0)

Report

Re: Automatically Send Email to Users 30 days prior to date

Dear @Anonymous ,
you should add an “Apply to each” control and put inside the Condition. The “select an output from previous step” must be the “value” got from the “list rows present in a table” action.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
Community Power Pla... on 08 Aug 2022 at 10:20:15

Like (0)

Report

Re: Automatically Send Email to Users 30 days prior to date

Hey @MarconettiMarco

thanks for your answer.

The condition makes perfect sense, but how do I iterate through all the excel rows?
As in the table, I have many rows and each date should be checked and in case the date is 30days ahead, the email should only be sent to the Email Corresponding in the row.

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 08 Aug 2022 at 07:52:10

Like (0)

Report
Re: Automatically Send Email to Users 30 days prior to date

Hello @Anonymous ,
you should add a "Condition" control:
1st parameter:
formatDateTime('<your_value>','yyyy-MM-dd')
is equal to

2nd parameter:
formatDateTime(addDays(utcNow(),-30),'yyyy-MM-dd')

if Yes, send an email.

Both dates must have the same ISO8601 format.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No