Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Planner
    • Outlook
    • SharePoint
    • Teams
  • Triggers
  • Resources
  • ABOUT ME
  • Get help with your flow
Menu

Get the user who completed a Planner task with Power Automate

Posted on May 1, 2022May 1, 2022 by Tom

“I’d like to receive an information about a completed Planner task, but Power Automate doesn’t tell me which user completed it!”


If you use the ‘When a task is completed’ Planner trigger, you’ll get a lot of dynamic contents. You get the author, the assigned user, the creation, start, due and completed date, but there’s no information who completed the task. The ‘Completed By’ dynamic content is just not there. Yet it’s still possible to get the information, and this post will show you how.

Extract it from the trigger output JSON

As already explained in the post on parsing JSON, dynamic contents only simplify your work. Power Automate will process the output from an action, and offer you the values it recognises as dynamic contents. If something is missing among the dynamic contents, it doesn’t mean that the information isn’t there. It just wasn’t offered directly.

Take the output from the trigger action, and place it in a text editor (I prefer Visual Studio Code). You’ll see that it contains the ‘completedBy’ property.

The information is there, you just need to extract it. The displayName will be empty, but there’s also the user id to identify the user. Take the user id using an expression.

triggerOutputs()?['body']?['completedBy']?['user']?['id']
Power Automate Planner user completed

Once you have the user id you can use it to search for the additional user information. Add the ‘Get user profile (V2)’ action, use the expression as the input, and take the information you need.

Power Automate Planner user completed

Summary

If you’re looking for something specific and you don’t see it among the dynamic contents, try to check the JSON output. As you can see in this post, even though Power Automate doesn’t offer directly the user who completed the Planner task, you can still extract it from the JSON. It’ll be only the user id as that’s what Planner gives you, but once you have it it’s easy to find the other user information.


Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Do you know what to do, but not how to do it?

Get The Ultimate Power Automate expressions cheat sheet and translate your thoughts into flows with ease!


There's also the HTTP requests to SharePoint cheat sheet to help you overcome limitations of some standard actions!

Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

  • How to find Excel rows missing in SharePoint list (Power Automate)March 29, 2023
  • Check whether user exists in AAD with Power AutomateMarch 26, 2023
  • How to highlight whole SharePoint row based on calculated dateMarch 22, 2023
  • Why is your Power Automate flow running so slow?March 19, 2023
  • How to add multiple links to the Power Automate approval taskMarch 15, 2023

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2023 Let's POWER Automate | Theme by SuperbThemes