cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Sending one reminder for multiple tasks

Task

Description

Status

Assigned to

Task1

Description1

Approved

Person1

Task2

Description2

Pending 

Person1

Task3

Description3

Pending 

Person1

Task4

Description4

Pending 

Person2

Task5

Description5

Pending 

Person2

 

How to create a reminder that sends one email only to the ‘Assigned to’ person containing the ‘Task’ and ‘Description’ columns if the status is ‘pending’? Eg in the case above the email for ‘Person1’ would contain Task2, Description2 and Task3, Description3, the email for ‘Person2’ would contain Task4, Description4 and Task5, Description5 and so forth.

I would like to avoid having one email for each person.

 

I can apply the condition ‘pending’ but I do not know how to pick the one email address.

Thanks for helping.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

Hi @Anonymous,

 

What is the type of the Status column in your sharepoint list?

 

I have made a test to create a Status column with a Single line of text type in the sharepoint list as below:

Capture.PNG  

 

You could refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

The user in the assigned to field would receive the email as below:

Capture.PNG

 

 

Best regards,

Alice

 

View solution in original post

12 REPLIES 12
v-yuazh-msft
Community Support
Community Support

Hi @Anonymous,

 

What is the type of the Status column in your sharepoint list?

 

I have made a test to create a Status column with a Single line of text type in the sharepoint list as below:

Capture.PNG  

 

You could refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

The user in the assigned to field would receive the email as below:

Capture.PNG

 

 

Best regards,

Alice

 

Anonymous
Not applicable

Thanks @v-yuazh-msft, what is inside the union? What is 'Assigned to(all)' uniting with? I get an error uniting against 'Assigned to(distinct). 

Hi @Anonymous,

 

The expression should as below:

union(variables('Assigned to(all)'),variables('Assigned to(all)'))

Best regards,

Alice

Anonymous
Not applicable

Thanks @v-yuazh-msft, brilliant solution. 

Anonymous
Not applicable

can you please explain the rationale for uniting a variable against itself? Thanks. 

Anonymous
Not applicable

@v-yuazh-msft 

Hi Alice,

 

One question, what if we have three tasks list created in three different subsites under same site collection. Task list is templated so columns and metadata values will be same. Is it possible to send a consolidated report out of tasks assigned to a user from all 3 task lists? The solution you provided here is for one task list, can we make some modifciation to make it fetch tasks assigned to a user from three different task list and notify him/her in one email.

 

Let me know please if that is possible.

Anonymous
Not applicable

OMG.  Thank you!  Finding this post was huge.  It is working great.

very good , it worked

Dear Alice,

I have a question about your flow. When rebuilding it, I got the following error message when saving the flow:
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Filter_array' at line '1 and column '2724' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Filter_array' to be referenced by 'repeatItems' or 'items' functions.'.'.

 
I think it has something to do with the second "apply to each" section in which "current item" refers to the first "apply to each" section. How to solve this? 

whistlingbird_0-1640089983584.png

 

Hi,

 

I keep getting this error when trying to save the flow.  Any idea what is causing it?

 

Cjohnson20_0-1645718388699.png

 

Anonymous
Not applicable

I faced the same problem.

 

Make sure in "filter array" to select "Current Item" from "Apply to each 2".....

 

I spent 2 days beacuse I select from Apply to each 1

Anonymous
Not applicable

did yuo find a solution?

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,296)