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
TitleDue DateStart DateProgressCompleted DateCreated 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 EachBucket – Yes but interferes with the Assigned valueLabel - Just gives a "true" but not the actual labelNotes - Do not see this available?Checklist - Do not see this available?Comments - Do not see this available?Notes/Description - just says "true" if filled outPriority - Do not see this available?