Hey everyone,
I am able to copy completed tasks to SharePoint from Planner but it is missing a few fields that we need. Our end goal is to bring the data into PowerBi so all of our reporting is in 1 place. If there is a better solution, please let me know. The export excel has a lot of issues and doesn't have all the columns we need either.
Able to easily copy these fields
Title
Due Date
Start Date
Progress
Completed Date
Created Date
Not these Fields
But when I try to do these other fields, I either can get the value or there is a conflict with multiple Apply to each. Does anyone have a sample flow that already combines these into 1 Apply to each and adds the actual value to SharePoint?
Assigned – Yes through Get User Profile and Apply to Each
Bucket – Yes but interferes with the Assigned value
Label - Just gives a "true" but not the actual label
Notes - Do not see this available?
Checklist - Do not see this available?
Comments - Do not see this available?
Notes/Description - just says "true" if filled out
Priority - Do not see this available?
------------------------------
Marie Castine
Web Developer
McDonough
------------------------------