44
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
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!!
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:
Share
Report
All responses (
Answers (
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
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
