cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Renato_LTA
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
efialttes
Super User III
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
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (51,958)