Monthly Summary Email to Assigned Users

(0) Share

Report

Posted on by AAallday

Hi,

I have a table that tracks annual site visits, due throughout the year, and at times assigned to multiple users.

For every "assigned to" set, I'd like to send a monthly email that summarizes site visits that are past due, and ones due next month. is this possible?

Such that:

john and joe get an email that lists the first facility and due date

john separately gets an email for the second facility

joe gets a separate email that lists both the fourth and fifth facility

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AAallday :

I am editing the solution, but before that, could you please mosaic your pictures? Because I noticed that your picture may contain a real email address.Please pay attention to protect your privacy.

Best Regards,

Bof

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AAallday :

Could you tell me:

What is Assigned to?Is it a "multiple lines of text" column?

I assume Assigned to is a "multiple lines of text" column.

I've made a test for your reference:

1\My SP List:

2\My Flow

Reference Expression:

take( union( split(variables('Assigned to'),outputs('Compose')), split(variables('Assigned to'),outputs('Compose'))), sub( length( union( split(variables('Assigned to'),outputs('Compose')), split(variables('Assigned to'),outputs('Compose')))), 1) )

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
AAallday 44 on at

Like (0)

Report
Copy link

Link copied!

Thanks for this, i'll be testing out. but to answer your question.. assigned to is an "person" field, pulling for the org directory.

and i made up the emails, for the image. thank you though!

Was this reply helpful? Yes No
AAallday 44 on at

Like (0)

Report
Copy link

Link copied!

In my test, the flow is successful but the last "apply to each" is greyed out, and no emails are sent.

Also, where would i add a condition for dates? meaning. i want to only pull "pending" and only if the due date is in this year (or earlier)

Thank you again!!

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AAallday :

My List:

My Flow:

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No