When Planner task is complete, add details to a SharePoint list

[BThis]

For my first Flow, I need to track completed Planner tasks in a SharePoint list. All I want to do is copy the task details including the task, assigned to, notes, labels, date completed, etc. into a SharePoint list. What do I do after "On completion" of a Planner task?  If I try to "Get task" it asks for an existing task name, but I want the task that was just completed.

Any help for a flow-building beginner would be appreciated. 

[v-bofeng-msft]

Hi @BThis ,

Please try this trigger,

Best Regards,
Bof

[BThis]

Thank you Bof, I started there, but that's as far as I got. The next step, I assume, would be to get the details of the Task. How do you do that? One template goes to SharePoint and "Get Items" but that doesn't make sense since it seems to be getting info from SharePoint, not from Planner. So how do I get all the Planner task details, and then how do I paste them into a SharePoint list? 

[BThis]

Wow, Bof, I watched the new Power Automate release update and saw the option to use AI to create a flow from a description. I wrote a description and it created almost exactly the flow I needed--Amazing! Except it contains an error and I don't know how to fix it. The "Item/Is Completed" is no longer available. How do I delete that? See below. 

[BThis]

I tried to create a new flow using the AI bot. The new flow works except that it only copies the title of the Planner Task into SharePoint, not all the task info, which is what I desire. 

[BThis]

I am still trying to create this flow. Does the trigger "When a Planner Task is completed" copy all the task details? Or do I need to copy them as a separate step? Then, how do I paste all the details into the SharePoint list? Do I need to configure the list to do this, or is it part of the flow to paste them in? Also, I don't see "Notes" as an option to copy. We use the Notes field to copy a link to the SharePoint site for the project, and I want to paste that into the SharePoint list along with all of the other details.

I would love to hear any suggestions for creating a SharePoint list entry including all of the Planner Task details including Title, Date Completed, Assigned to, Notes, Labels, and other info. 

[BThis]

Please help! I am still trying to create a flow to copy the task details when a Planner Task is completed into a list in SharePoint. The Planner Connector action When a Task is completed, Operation ID OnCompleteTask_V3, returns the response ListTasks_Response_V2. That response is an array of GetTask_Response_V2. That array contains most of the task info, although some key items I need such as Notes and Description are not included.

So, if I start with When a Task is completed, how do I retrieve the array that is in the response, and how do I copy it or move it into a SharePoint list? Once I can get that far, perhaps then I can figure out how to update the SharePoint list entry with the Notes and Description and any other missing elements. 

@v-bofeng-msft or anyone else, I would deeply appreciate some guidance or direction as to where I might find these answers. 

[v-bofeng-msft]

Hi @BThis ,

Please try:

Best Regards,

Bof

[BThis]

That's helpful, @v-bofeng-msft , but how do I enter the task ID variable in the "Get task details" step? Clicking the field only lists the current tasks. Is there a way to list the variables from the previous step, or code to enter to indicate the flow should use the task ID from the previous step?

Is there a source somewhere where I can look things like this up?

[BThis]

I have made more progress using the AI-based method and the steps below. When it runs, it enters the Title of the Planner Task in SharePoint. But that is still the only thing that is entered in the SharePoint list even though all the other information is in the Create Item step. Please tell me, how can I get all that info into the SharePoint list?

 Here's the result: 

[BThis]

I've now progressed my Flow to include nearly all of the items I need in the SharePoint Create Item step, based on columns in the targeted SharePoint list. I assign the appropriate variable to each column, such as Completion Date, Description, AssignedTo Id, etc. Still, the only information the Flow posts in the list is the Description. How do I get the other data to post into the SharePoint list? 

And, why is there no source of information on how to accomplish simple things like this? I am a technical writer and would be happy to document this process if I could figure out how to do it. This is very frustrating. 

[BThis]

Wow, I've made progress! Now I've got the flow to enter the Planner Task data into the SharePoint list. But there are at least two issues. First, several items that are text entries show up in the SharePoint list as code/gibberish, such as "MrAK9J7jn02hWC1vCUIyKGUAAb1N" which should be the BucketID, which is a person's name, or "

2caa78cd-9ade-47fb-9af0-c5af42cd42f0," which is AssignedTo, another person's name. How do I get these to enter in the SharePoint list as English text? 
Second, we use Labels in Planner to designate aspects of our services that are included in the task. We renamed the colored labels for the geography (US, UK, EU, CA, etc.) or services we're proposing (Fulfillment, Fraud Management, etc.) For each of these, the Flow enters "True." What I need it to do is, if that Label is "True," enter the label as we have edited it. For example, if the label "UK" is True, enter "UK." Is there a way to do this?

[Dom1991]

Hi, did you ever solve this? Ive got to do exactly the same and struggling to get planner to talk to SharePoint lists. @BThis @v-bofeng-msft 

[bthistlethwaite]

Hello @Dom, sorry, I never solved it. My last determination was that Planner was not set up to extract the needed data in a usable format, and/or SharePoint could not interpret the data that is being extracted from Planner. I assume MS needs to complete the connector between Planner and SharePoint so it's usable. Toward the end, my BI flow would fill in a row of data in my SharePoint table, but it was mostly useless gibberish. 
I hope you can get it working! Good luck.
  --BThis