cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Send reminder for sharepoint overdue tasks

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

5 REPLIES 5
Dual Super User III
Dual Super User III

Hi!

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

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Hi,

thanks for the reply.

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

 

Annotation 2020-02-20 121432.jpg

The error I get is this one

 

capture.png

Thanks!

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

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

and they both work! Thanks!

Hi

Glad to see you found another valid approach 😉

Happy Flowing!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (12,975)