cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Dual Super User III
Dual Super User III

Re: Send reminder for sharepoint overdue tasks

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
Highlighted
Dual Super User III
Dual Super User III

Re: Send reminder for sharepoint overdue tasks

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!



Highlighted
Frequent Visitor

Re: Send reminder for sharepoint overdue tasks

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!

Highlighted
Dual Super User III
Dual Super User III

Re: Send reminder for sharepoint overdue tasks

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

Highlighted
Frequent Visitor

Re: Send reminder for sharepoint overdue tasks

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

and they both work! Thanks!

Highlighted
Dual Super User III
Dual Super User III

Re: Send reminder for sharepoint overdue tasks

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,068)