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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Help Needed: Flow to E...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 4

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

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:

 
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

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,325 Super User 2025 Season 2 on at
     
    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.
     
  • Verified answer
    Tomac Profile Picture
    3,948 Moderator on at
    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.
  • CU22070719-0 Profile Picture
    4 on at
    Hi @Tomac , @Michael E. Gernaey, I tried the sample flow , it still doesn’t works gives me errors , I have two condtions for the due date and the employee - Manager email Task duedate Notification  , The DueDateTime is as you suggested , the taskDueDate = outputs duedatetime Is less or equal to today minus 2 , the other is outputs duedatetime equal to todayminus1 
  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at
     
     
    I think @Tomac expression is correct - could you check whether due date value exists for the task for which you are iterating ?
     
     

    Thanks & Regards,
    Nived N

    Stay connected:
    LinkedIn | YouTube | Blogs

    Was this answer helpful?
    If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
    Your feedback motivates me to keep contributing. 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard