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

Announcements

Agent Academy Hackathon is happening now!
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How do I setup this re...
Power Apps
Unanswered

How do I setup this recurring planner task

(0) ShareShare
ReportReport
Posted on by TrevorG 8

So I am trying to setup a few recurring task, However I want some of the info to be entered dynamically. 

planner stuff.jpg

So in the due date how do I let it dynamically set it to be exactly a week from the start date? I am guessing you take the start date and add 7? So we can do the now function again and add 7? is this the best way?

 

How can I also dynamically increment the title to say something like this. Weekly Task (week 5) where 5 is the 5th week of the year. 

Categories:
Building Power Apps
I have the same question (0)
  • v-jefferni Profile Picture
    v-jefferni Microsoft Employee on at

    Hi @TrevorG ,

     

    For the first question, you could create two variables 1 stands for today, the other use variable1 to get the date a week after. Both variables are Text format. Then you could use

     

     

    FormatDateTime(variables('utcNow+7'))

     

     

    in Expression to get the date value:

    71.png

     

    For the second question, you could add a label to count the week number and use the result in the Flow:

    72.png

    The formula of counting week numbers is from:

    https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-calculate-week-number/td-p/20161/page/3

     

     

    "Weekly Task (week & "
If(
 Or(
 And(
 Year(DatePicker_tr.SelectedDate) / 4 - Round(Year(DatePicker_tr.SelectedDate) / 4,0) = 0,
 Weekday(Date(Year(DatePicker_tr.SelectedDate),Month(1),Day(1))) = 4
 ),
 Weekday(Date(Year(DatePicker_tr.SelectedDate),Month(1),Day(1))) = 5
 ),
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)+1, // Makes 53 weeks in a year
 If(
 And(
 Or(
 Weekday(Date(Year(DatePicker_tr.SelectedDate),12,31)) = 2,
 Weekday(Date(Year(DatePicker_tr.SelectedDate),12,31)) = 3,
 Weekday(Date(Year(DatePicker_tr.SelectedDate),12,31)) = 4
 ),
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)=53
 ), 
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)-52, 
 If (
 And(
 Or(
 Weekday(Date(Year(DatePicker_tr.SelectedDate),12,31)) = 2,
 Weekday(Date(Year(DatePicker_tr.SelectedDate),12,31)) = 3,
 Weekday(Date(Year(DatePicker_tr.SelectedDate),12,31)) = 4
 ),
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)=52
 ),
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)-51,
 If(
 And(
 Or(
 Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1)) = 6,
 Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1)) = 7,
 Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1)) = 1
 ),
 Or(
 And(
 Year(DatePicker_tr.SelectedDate-1) / 4 - Round(Year(DatePicker_tr.SelectedDate-1) / 4,0) = 0,
 Weekday(Date(Year(DatePicker_tr.SelectedDate-1),Month(1),Day(1))) = 4
 ),
 Weekday(Date(Year(DatePicker_tr.SelectedDate-1),Month(1),Day(1))) = 5
 ),
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)=0
 ),
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)+53,
 If(
 And(
 Or(
 Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1)) = 6,
 Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1)) = 7,
 Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1)) = 1
 ),

 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)=0),
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)+52,
 If (
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)=0,
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)+1,
 If (
 And(
 Or(
 Weekday(Date(Year(DatePicker_tr.SelectedDate-1),12,31)) = 2,
 Weekday(Date(Year(DatePicker_tr.SelectedDate-1),12,31)) = 3,
 Weekday(Date(Year(DatePicker_tr.SelectedDate-1),12,31)) = 4
 ),
 RoundDown((Date(Year(DatePicker_tr.SelectedDate-1),12,31) - Date(Year(DatePicker_tr.SelectedDate-1),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate-1),1,1) - 1,Monday))) / 7,0)=52
 ),
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)+1,
 RoundDown((DatePicker_tr.SelectedDate - Date(Year(DatePicker_tr.SelectedDate),1,1) + (Weekday(Date(Year(DatePicker_tr.SelectedDate),1,1) - 1,Monday))) / 7,0)
 )
 )
 )
 )
 )
 )
)
& ")"

     

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • TrevorG Profile Picture
    TrevorG 8 on at

    Ok let me try it then I will comment. I have a question first though 

     

    Screenshot 2020-12-22 080938.jpg

    What is the difference between 'create a task' and 'create a task (preview)'

     

    **Update**

    Also shouldn't that utcNow+7 be just Now+7 since thats the name of the variable we created? I am new to this its my very first flow. And how did you enter the script for the title?

  • v-jefferni Profile Picture
    v-jefferni Microsoft Employee on at

    Hi @TrevorG ,

     

    For the first question, tiny little difference between them, the preview one has the parameter "Priority" which could help set priority of the task in the Flow. You could refer to below doc to know about other actions:

    https://docs.microsoft.com/en-us/connectors/planner/#create-a-task

     

    For your second question, ah you are right it's a typo. The title just use "Ask in PowerApps", since with the formula in a Label, we could use Label.Text in the Flow to pass the message.

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • TrevorG Profile Picture
    TrevorG 8 on at

    Yes that helps. It working well except for the title I have not found where I need to put that very long script. can you help me with that?

  • v-jefferni Profile Picture
    v-jefferni Microsoft Employee on at

    Hi @TrevorG ,

     

    Sorry for the delay. But you need to look into my above post and follow the steps. You could add a Label and apply the long codes on the Text property. Then the Label.Text is the result of the week number and you could leverage the result in your flow.

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

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

News and Announcements

Agent Academy Hackathon is happening now!
Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 846

#2
Valantis Profile Picture

Valantis 532

#3
Haque Profile Picture

Haque 410

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans