Hi all,
I've created flows where based on a mail or MS Forms a task in MS Teams is created. I want to add a due date which should be one working day after "receiving day" at 4pm.
I can't find a way to do this. Can anyone help me?
Thanks!
Jana
Solved! Go to Solution.
You should be able to add a due date as the image below:
and then the formula:
addDays(utcNow(),1,'yyyy-MM-dd')
You should be able to add a due date as the image below:
and then the formula:
addDays(utcNow(),1,'yyyy-MM-dd')
Hi @StretchFredrik,
thanks for the formula! That's already a great help. Is it possible to add somehow that the due date should not just be the next day but the next working day? So that if a mail comes in on Friday the due date is set to Monday?
Thanks!
Jana
For sure, you just have to make some if statements to check the following:
Use a dayOfWeek() expression - that will return Sunday as 0 and Saturday as 6.
If this solved your issue please mark the post as Solved.
Also, if you appreciated my answer, don't forget to give it a Thumbs Up 😃
How exactly does the formula have to look? and can 4pm be added to the due date as well?
For me it returns the following error for the week days: Unable to process template language expressions in action 'Create_a_task' inputs at line '0' and column '0': 'The template language function 'DayOfWeek' expects a single parameter that is a timestamp. The function was invoked with '3' parameter(s).
Thanks for your help! I'm a Newbie when it comes to Power Automate so I really appreciate it
User | Count |
---|---|
89 | |
41 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
51 | |
48 | |
36 | |
26 |