web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating workflow with...
Power Automate
Unanswered

Creating workflow with sharepoint and planner

(1) ShareShare
ReportReport
Posted on by 16

Hi,

 

I am mid-flow and have encountered the limits of my knowledge on PA.

 

So far, my workflow will create a Planner task from my Sharepoint list whenever a new entry is created in Sharepoint. The task generates a specific checklist, assigns a user, and has a due date. This then also triggers other items in other columns (Sharepoint) to have new values.

 

What I would like to do next is to work into the workflow the following conditions:

 

1) When the checklist of a task is ticked off completely in Planner, this will automatically update the task as complete, which will update a specific column value to update (re - 'In progress' > 'Completed').

 

3) If the due date passes, but the task has been marked as complete (because the checklist being completed did this automatically), there will be no change in any values as the changes have already been triggered by the first step (above).

 

3) If the due date for the task passes, but the checklist has not being ticked off fully, this triggers a similar update in a Sharepoint column item but with a different value (re - 'In progress' > 'Breach') and a separate overall Status column value (re - 'On track' > 'Off track').

 

I am at the beginnings of this workflow but the conditions above will recur continually from E2E.

 

Any help would be appreciated.

Categories:
I have the same question (0)
  • sandeepstw Profile Picture
    312 Moderator on at

    Hi There,

     

    Use the "When a task is completed" trigger in Power Automate for the Planner. Use the "Get task details" action to get the checklist details. Set up a condition to check if all checklist items are marked as completed.

     

    If true (all items are complete), use the "Update item" action for SharePoint to change the column value to 'Completed'.

     

    Use a recurrence trigger in Power Automate to periodically check tasks. Utilize the "List tasks" action for Planner and filter by due date.

     

    For each task, get the checklist details. Set a condition to check if the due date has passed and checklist is incomplete.

     

    If true (due date passed and checklist not complete), use "Update item" action for SharePoint to change the column value to 'Breach' and 'Off track'. Else if the task is complete, no further action is needed.

     

    Please give kudos and mark as solution if it helps.  

      

    Thanks, 

    Sandeep Mishra 

  • sandeepstw Profile Picture
    312 Moderator on at

    Hi ,

     

    Please mark as solution if it helps.  🙂

  • heathR2 Profile Picture
    16 on at

    Hi, it is helpful but I am new to PA and I was hoping for more specific instructions, step-by-step.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard