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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create an annual plan ...
Power Automate
Unanswered

Create an annual plan using Flow? Any ideas

(0) ShareShare
ReportReport
Posted on by 424

Hello,

I am testing a bit around annual plan automation using Flow and Forms Pro.

As a background, my customer have a yearly calendar with tasks that executives need to carry out during different months through out the year. For example, in january they should book a meeting with all individuals that report to them. In other months there are other tasks to complete.

The problem is the follow up on all tasks. They would like to automate as much as possible so that its easy to find out which tasks has been completed and which one that are left behind.

 

My ideas so far:

 

1. Create a sharepoint list that includes the annual calendar including start date, end date, task type, links to steering documents etc

2. Let the Flow run once a day and look for start dates that matches Now().

3. When the Flow makes a hit on the date it creates Planner Tasks and assign to each executive.

4. Another Flow checks for tasks not completed in time and sends reminders.

 

Anyone who has done something like this?

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,697 Most Valuable Professional on at

    That is exactly how I would recommend doing it. Do you have any specific questions about any of the steps?

     

    Right now the one thing that will cause you the most trouble is checking the date against Now().  DateTime columns in SharePoint always include both a date and a time, even when they are set to only display the date.  So when comparing to Now() it tries to match both the Date and the Time and therefore usually returns false. To get around this cast both the column and the Now() using formatDateTime() to a date only format that is the same.  Then compare the strings.

  • MagnusGöransson Profile Picture
    424 on at

    Hello Paul,

    Thanks. Yeah, I have been messing around with that before. I think i have made a "larger than" and "smaller than" comparison but I may be wrong.

    I will keep this thread open and post my findings here during the development.

    Right now I am messing with "get group members" to find all executives and then find all that the executives report to. Takes a while just to test when there is a lot of users. 

  • Pstork1 Profile Picture
    68,697 Most Valuable Professional on at

    I agree its going to be a pretty complex Flow.  The greater than and less than should also since it uses a range that includes the time and date.

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard