IF statement error

Like (0) Share

Report

Posted on 7 Apr 2022 10:54:05 by PowerAutomate3

Hello

I need to convert months to their respective quarters, any idea why the below does not work?

if(int(formatDateTime(utcNow(),'M'))<4,'Q1',if(int(formatDateTime(utcNow(),'M'))<7,'Q2',if(int(formatDateTime(utcNow(),'M'))<10,'Q3','Q4')))

Thanks!

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (6)

Answers (1)

joelzehring 208 on 27 Apr 2022 at 15:42:31

Like (1)

Report

Re: IF statement error

I don't think that will work in your use case.

Expression Evaluated
utcNow('M') April 27
utcNow('MM') 04

More info: Standard date and time format strings | Microsoft Docs

Was this reply helpful? Yes No
PowerAutomate3 53 on 27 Apr 2022 at 15:15:35

Like (0)

Report

Re: IF statement error

@joelzehring I think the problem is that I used 'M' instead of 'MM'. I really wanted to use e.g. 1 for January and not 01. Isn't it possible? Why it results in an error?

Was this reply helpful? Yes No
joelzehring 208 on 07 Apr 2022 at 23:45:03

Like (0)

Report

Re: IF statement error

I'm not able to reproduce that error... Can you share a screenshot of where you're using this line of code and any modifications you may have made?

Was this reply helpful? Yes No
PowerAutomate3 53 on 07 Apr 2022 at 23:34:47

Like (0)

Report

Re: IF statement error

Thanks but I get the error:

The template language function 'int' was invoked with a parameter that is not valid

Any ideas?

Was this reply helpful? Yes No
joelzehring 208 on 07 Apr 2022 at 18:29:39

Like (1)

Report
Re: IF statement error

Nested "if" expressions can be a pain, so I took a slightly different approach. The below expression is just returning the quarter number, which can be concatenated with a "Q" later:
if(greater(mod(int(utcNow('MM')),3),0), add(div(int(utcNow('MM')),3),1), div(int(utcNow('MM')),3))

Was this reply helpful? Yes No
Verified answer

Expiscornovus 32,292 Most Valuable Professional on 07 Apr 2022 at 14:36:07

Like (3)

Report
Re: IF statement error

Hi @PowerAutomate3,

Instead of the < character you could use the less function in your expression.

You can also simplify the expression a bit. You can remove the formatDateTime functions. Try the expression below.

if(less(int(utcNow('MM')), 4), 'Q1', if(less(int(utcNow('MM')), 7), 'Q2', if(less(int(utcNow('MM')),10), 'Q3', 'Q4')))

Was this reply helpful? Yes No