Finance | Project Operations, Human Resources, ...

Use PowerAutomate to send monthly emails with dates from sharepoint list

(0) Share

Report

Posted on by MagnusWM

Hi all!

I have made a sharepoint list with important dates for events coming up for the next 10+ years. I wish to generate a flow via PowerAutomate which can send me a monthly email which informs me the events coming up for the coming month (based on the dates in sharepoint list).

Can you help?

Thanks a lot!,

Magnus

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Community Member on at

Like (2)

Report
Copy link

Link copied!

Hi,

You can refer to my flow:

1. You can first use the Recurrence trigger to trigger the flow in the last few days of each month:

2. Then use Get items to get the values in the list:

3. Predefine a variable to receive events:

4. Then determine whether it is an event that needs attention next month:

Expression:

int(formatDateTime(item()?['date'], 'MM'))

add(int(formatDateTime(utcNow(), 'MM')),1)

5. Finally, all events in the next month will be notified to users via email:

Result:

Only a small amount of test data was constructed, but the results are accurate:

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Frank Gong

Was this reply helpful? Yes No
MagnusWM 10 on at

Like (0)

Report
Copy link

Link copied!

Dear Frank,

Thanks a lot - you're the best!! The flow almost works. The only issue is that the Flow email correctly gives me the events for next month (September) but also include events from the other years (September events for 2021 as well as 2023).

Are there a way to fix this? Also, it send multiple emails instead of sending one with all events in it.

Thanks a lot!

Magnus

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi,

You can click Add in the condition, and then add the comparison (year) as shown in the figure below:

Sending mail is outside the loop:

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Frank Gong

Was this reply helpful? Yes No
MagnusWM 10 on at

Like (0)

Report
Copy link

Link copied!

Hi again Frank,

Thanks, really appreciate it!! I've followed all your instructions, however since I have now placed the "Send Email" outside the "Apply to each", it doesn't not include any events. In the email the Event tap is empty. See below:

See my flow above. The empty email below.

Anyway to fix this? Thanks!

Was this reply helpful? Yes No