Calculate if date is current or prior week

(0) Share

Report

Posted on by Spaceballs

Hi,

I'm trying to compare a Date if is this current or last week but I keep getting error. Can you help?

if(
 and(
 lessOrEquals(addDays(utcNow(), mul(dayOfWeek(utcNow()), 0), 'MM-dd-yyyy'), 
 formatDateTime(utcNow(), 'MM-dd-yyyy')),
 greaterOrEquals(addDays(utcNow(), add(6, mul(dayOfWeek(utcNow()), 0)), 'MM-dd-yyyy'), 
 formatDateTime(utcNow(), 'MM-dd-yyyy'))

,'Current','Past'))

I'm getting this error

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'if' expects three parameter: the condition to test as the first parameter, the value to return if the condition is true as the second parameter, and the value to return if the condition is false as the third parameter. The function was invoked with '1' parameter(s). Please see https://aka.ms/logicexpressions#if for usage details.'.

Categories:

General topics

All responses (3)

Answers (0)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Spaceballs

You can't use operators like <= or >= in Flow expressions. You need to use comparison expressions such as less() and lessOrEquals(), etc.. Your expression will end up being way complicated - I suggest doing it in a number of steps using Compose actions.

I approached this a little differently using a series of Compose actions and converting the dates to ticks,
Spaceballs 64 on at

Like
a
(0)

Report
Copy link

Link copied!
In the Sharepoint list I have three calculated fields

StartWeek
=ApproveDate-(WEEKDAY(ApproveDate,3))

EndWeek
=ApproveDate+(6-WEEKDAY(ApproveDate,3))

WeekdayFlag
=IF(AND(WeekStart<=TODAY(),WeekEnd>=TODAY()),"This week","Past Week")

How can I translate back to the Power Automate in one expression rather than split it into multiple variables. One compose to rule them all 🙂
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Spaceballs

Try replacing the operators like + - >=, etc. with expressions as i mentioned in my earlier post. Give it a try and post any questions that you have here but give it a try......