Creating a Flow for a list of tasks in SharePoint Lists - to send out email notifications for upcoming tasks

[Anonymous]

Hi, 

I am trying to build a flow for a Tasks List in SharePoint list. I want to be able to send out a list of upcoming tasks (say in the next 14 days) in a table format in an email sent to the 'owners' of the task. 

Right now i am only able to build a flow which 'Applies to each' and send's out one email notification per task rather than all the tasks in one email. Is there any way to build a flow that allows ONE email notification per owner?

Regards

R

[v-bacao-msft]

Hi @Anonymous ,

Please refer to the following method to configure your Flow.

• Use Filter Query to filter out eligible items.
• Then integrate all Assigned to email into one array variable and remove duplicate emails.
• Finally, create an HTML table and send an email to all owners.

Image reference:

Best Regards,

[Anonymous]

Thanks Barry, 

I have followed your instructions step by step and the flow fails at the send email module of the Flow: see below:

it gives me the following error:

Kind regards

R

[v-bacao-msft]

Hi @Anonymous ,

In To field, you need to use the output of Join action.

Best Regards,

[Anonymous]

it still returns with the same error message - not sure where it is going wrong

[Anonymous]

i think it may be due to this:

In the Apply to each 2, it doesnt give me the option to select 'Assign to'

think that is where it is going wrong

Regards

R

[v-bacao-msft]

Hi @Anonymous ,

It seems that you are not using the Tasks list but a normal SharePoint list.

So the Assigned To is not an array.

Please share more details about the fields contained in the List.

In addition, you can try to remove Apply to each 2 and configure Append to array variable action directly in Apply to each.

Best Regards,

[Anonymous]

Hi,  - Apologies for not being clear that it is a normal SharePoint List. 

Its is a Sharepoint list that contains the following fields :

Task name - text

Description - text

Due Date - Date format

Status - choice format

Comments - text

 and a couple of other text columns for various dropdowns

[Anonymous]

Sorry forgot to add the the person columns:

Assigned to

Manager

regards

R

[v-bacao-msft]

Hi @Anonymous ,

Thank for your reply.

If this is the case you described, and the Assigned to field does not allow multiple selections, I think you can refer directly to the method provided by my previous reply.

you can try to remove Apply to each 2 and configure Append to array variable action directly in Apply to each.

If there is still a problem, please provide the details of the error message.

Best Regards,

[Anonymous]

Hi, 

Thanks for above

The flow works in the sense that it successfully sends a list of tasks in a tabular format in an email (in one email, rather than multiple). But the filtering array aspect of the flow is not working. It is giving me all tasks (past due date + ones that are due in more than 14 days). 

please see below:

Please advice how i can ensure the filtering array works

Thanks