Sending one reminder for multiple tasks

[Anonymous]

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.

[v-yuazh-msft · Accepted solution]

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:

  

You could refer to screenshot below to create the flow:

The flow would run successfully as below:

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

Best regards,

Alice

[Anonymous]

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). 

[v-yuazh-msft]

Hi @Anonymous,

The expression should as below:

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

Best regards,

Alice

[Anonymous]

Thanks @v-yuazh-msft, brilliant solution. 

[Anonymous]

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

[Anonymous]

@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]

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

[Bagulhem]

very good , it worked

[whistling-bird]

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? 

[Cjohnson20]

Hi,

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

[Anonymous]

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]

did yuo find a solution?