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

8 REPLIES 8
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

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. 

@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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,087)