You’re offline. This is a read only version of the page.
22
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.
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
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
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 "
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.
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:
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?
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.
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.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
