web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send reminder for shar...
Power Automate
Answered

Send reminder for sharepoint overdue tasks

(0) ShareShare
ReportReport
Posted on by 20

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

 

Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at

    Hi!

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

    Thanx!

  • Renato_LTA Profile Picture
    20 on at

    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!

  • Verified answer
    efialttes Profile Picture
    14,756 on at

    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 Profile Picture
    20 on at

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

    and they both work! Thanks!

  • efialttes Profile Picture
    14,756 on at

    Hi

    Glad to see you found another valid approach 😉

    Happy Flowing!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard