Send reminder for sharepoint overdue tasks

[Renato_LTA]

Hello,

I created a company planner tool that among many other fields, it uses AssignedTo (people field) to set the assignee of the task. Only one person is assigned to a single task (in the field settings I set not to allow multiple people).

I'd like to set a Flow that sends a reminder to the assignee N days before the due date contained in another field. The email will contain ALL the tasks for a specific assignee

I tried to replicate THIS POST but for an unknown reason it fails when appending the value to the array; this could be because my AssignedTo field is not allowing multiple people and for some reason flow handle a single user not as an array.

Is there a way to achieve the same goal in my scenario?

Thanks in advance for any help

[efialttes]

Hi!

Can you share a screenshot of your Flow so far in edit mode?

Thanx!

[Renato_LTA]

Hi,

thanks for the reply.

I kept in my test only the section that doesn't work (the last step)

The error I get is this one

Thanks!

[efialttes · Accepted solution]

Hi again

Thanks for your last detailed post. I think your current problem is: you expect SP List 'AssignedTo' column output to be an array of elements (each element a Person object), but the output is actually a single Person object, not an array.

So, I would replace your current expression and try with this instead:

item()?['AssignedTo']?['Email']

Hope this helps

[Renato_LTA]

Thanks, I tried both your solution and another approach from HERE

and they both work! Thanks!

[efialttes]

Hi

Glad to see you found another valid approach 😉

Happy Flowing!