Forum Discussion
Automatically updating SharePoint list project completion
Hi All,
I'm fairly new to SharePoint, and my organization is looking to use the system to track multiple projects at a high level.
I've created a list that has a '% Completion' column. I want this column to be automatically updated based on an uploaded connection list to Planner. i.e., if I mark two tasks as complete, I want the other list to update to reflect this.
Is there any way to do this? Or, is there a way to use a lookup column and pull the average % completion, rather than a selection of the % complete of each task?
TYIA
2 Replies
alvarado123 the SharePoint list cannot lookup data from Planner. You'll need to build a flow in Power Automate that when a task is marked as complete in Planner it updates a column in the list.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)Thanks, Rob_Elliott
The problem I'm facing with flows is that we have multiple projects, with multiple Planner files, and I'm unsure how to match Planner A with Project Entry A, Planner B with Project Entry B, etc. Is there a way to create a dynamic pull that matches name of Planner file to name of list in SharePoint?
