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 / Sending Reminders for ...
Power Automate
Answered

Sending Reminders for Planner Tasks

(0) ShareShare
ReportReport
Posted on by 41

I am trying to build an Automate flow to send reminder emails to Planner task assignees. I live in the gov't version of O365 so the built-in email reminder functions of Planner do not work. I've successfully got all the tasks filtered into an array and when I look at the output of the array, I see the assignee userID but I cannot figure out how to reference it (it's not listed as an available dynamic content).

 

This is the basics of the flow so far (I had a bunch more in there but have deleted it):

JamesWo_0-1637785134462.png

When I run the flow as is (ending when the array filter step is completed), I can look at the output and see the data I want:

JamesWo_1-1637785217700.png

So, I used that information to run the Get User Profile action and just hand jamming this in the UPN field: @items('Apply_to_each')?['_assignments']?['userId'], which it seems to like as it resolves to an object vice the text.

JamesWo_2-1637786083206.png

But when I test it, I get this error:

 

JamesWo_3-1637786132805.png

 

Categories:
I have the same question (0)
  • JamesWo Profile Picture
    41 on at

    It appears this template (Send reminder email for incomplete Planner tasks in a plan) might be helpful if someone can expand it all and post screenshots. I have very little templates in my tenant.

  • JamesWo Profile Picture
    41 on at

    After more digging and learning, I think the problem is that when I filter the task list into an array, it's putting the task assignments in an array for each task. I believe that error message is a result of the nested arrays. Still trying to figure out how to parse the information from the nested array.

    JamesWo_0-1637796531804.png

     

  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @JamesWo ,

     

    Please try this:

    vxiaochenmsft_0-1638178604928.png

    vxiaochenmsft_1-1638178616053.png

    vxiaochenmsft_2-1638178627070.png

     

    items('Apply_to_each')['_assignments']
    items('Apply_to_each_2')['userId']
     
    Best Regards,
    Wearskky

     

     

     

  • JamesWo Profile Picture
    41 on at

    That worked perfectly! Thank you!

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 997

#2
Valantis Profile Picture

Valantis 810

#3
Haque Profile Picture

Haque 642

Last 30 days Overall leaderboard