Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Suggested answer

Help Needed: Flow to Email Assigned User or Manager Based on Task Due Date on Planner

(0) ShareShare
ReportReport
Posted on by

I'm building a Power Automate flow that loops through Microsoft Planner tasks and:

  • Emails the assigned user if the task is due tomorrow

  • Emails the Manager if the task is 2 days overdue

The issue:

I'm stuck at extracting the assigned user ID from the assignments field.
I'm using a step called ExtractAssignedUserId, but it fails with:

 
pgsql
 
The template function 'keys' is not defined or not valid.

What I need:

  • Correct way to extract assigned user ID/email from the task

  • Help structuring the conditionals (due tomorrow or 2 days overdue)

  • General review of the logic in the screenshot

  • Suggested answer
    Tomac Profile Picture
    761 Moderator on at
    Help Needed: Flow to Email Assigned User or Manager Based on Task Due Date on Planner
    Here's a sample flow that will accomplish your goal:
     
    In the Condition, I'm comparing these two values:
    formatdatetime(items('Apply_to_each_2')?['dueDateTime'],'yyyy-MM-dd')
    adddays(formatdatetime(utcnow(),'yyyy-MM-dd'),1)
     
    And in the Get User Profile I'm using:
    item()['userId']
     
    This flow works when tested. If this resolves your issue, please mark it as the answer.
  • Michael E. Gernaey Profile Picture
    44,960 Super User 2025 Season 2 on at
    Help Needed: Flow to Email Assigned User or Manager Based on Task Due Date on Planner
     
    Please open the actions themselves, share the inputs and outputs from the run, as well as the configuration details not in run time.
     
    Need to see what you put in there, and need to see what it actually tried to do.
     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2