Share via

Power automate alerts for planner late tasks

Zitok, Chen 0 Reputation points
2026-02-04T08:08:23.57+00:00

Hi, trying to generate a power automate alert that will send a personal teams message (chat with flow bot) to users who has late planner tasks (due date is less than today).

I managed to generate the flow but the issue is with the recipient, i cannot dynamically update the recipient by the task assignee as planner does not store users details besides Azure user ID. tried getting user profile but it did not work (again, asking for user details which i don't have), also some of the options are not available on my corporate license.

Do you have any other solution besides posting in a channel? this is not effective as users tend to ignore it, we need it to be sent individually to each user on a weekly basis preferred by teams.

Microsoft 365 and Office | Project | For business | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rin-L 14,135 Reputation points Microsoft External Staff Moderator
    2026-02-04T08:49:27.78+00:00

    Hi @Zitok, Chen, 

    Thank you very much for taking the time to share your question with us in the Microsoft Q&A forum. 

    Based on your description, it looks like the challenge you’re facing is closely tied to a Microsoft Power Automate (Flow) scenario, particularly around design logic and licensing behavior rather than a core Microsoft 365 feature.  

    As this forum category mainly focuses on Microsoft 365 and Office products, our coverage and hands‑on expertise with Power Automate‑specific configurations, connectors, and licensing considerations are unfortunately quite limited. To make sure you receive the most accurate, in‑depth guidance and to avoid the risk of giving you incomplete or misleading information, I’d recommend posting your question in the Microsoft Power Platform Community instead.  User's image

    This community is dedicated to Power Automate and related services, and it’s actively supported by specialists and experienced partners who work with these scenarios on a regular basis. There, you’ll be able to connect with contributors who have practical experience with Planner connectors, Azure AD user resolution, licensing constraints, and alternative notification approaches that go beyond channel‑based messaging. 

    I truly apologize for redirecting you to a different community, and I sincerely appreciate your understanding. My goal is simply to help you get the best and fastest possible support by guiding you to the forum that’s best equipped to assist with your specific use case.  

     Thank you again for your patience and cooperation. I wish you the very best of luck with refining your flow design, and I hope you’ll find the detailed assistance you’re looking for soon.   

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

    0 comments
  2. Q&A Assist
    2026-02-04T08:08:34.3+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    To create a Power Automate flow that sends individual Teams messages to users with late Planner tasks, you can follow these steps:

    1. Get Late Tasks: Start by using the "List tasks" action from the Planner connector to retrieve tasks that are assigned to users and have a due date less than today.
    2. Iterate Through Tasks: Use a "For each" loop to iterate through the tasks retrieved. For each task, you will need to extract the assignee's Azure user ID.
    3. Get User Profile: To convert the Azure user ID into an email address or Teams user ID, use the "Get user profile (V2)" action from the Office 365 Users connector. This action requires the user ID as input and will return the user's email address.
    4. Send Teams Message: After obtaining the user's email, use the "Post a message in a chat or channel" action (selecting the option to post in a chat) to send a personalized message to each user. You can customize the message to include details about their late tasks.
    5. Schedule the Flow: Set the flow to run on a weekly basis using a recurrence trigger.

    If you encounter limitations with your corporate license, consider discussing with your IT department about enabling necessary connectors or actions that may be restricted. Alternatively, you can explore using adaptive cards for more interactive messages if supported.

    References:

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.