Create a Logic function in a flow with 3 parameters

Like (0) Share

Report

Posted on 2 Dec 2022 08:17:09 by Sri

559

Hi All,

I am building a flow to generate report and send mail to the respective managers with HTML content. I have three IF conditions to be satisficed only then it should be true. The condition I have written is:

if(equals(items('Apply_to_each_4')?['Project Type'],'Dev-Enh_Upgr-Impl'),equals(items('Apply_to_each_4')?['Project Method'],'Traditional Development'),
equals(items('Apply_to_each_4')?['Projectcontract'],'T & M'))

only if all the three conditions matches this condition must be true. If I use AND function I am getting a error stating :

Unable to process template language expressions in action 'Append_to_string_variable' 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 '2' parameter(s).

Any help on this would be greatly appreciated.

All responses (4)

Answers (0)

Sri 559 on 02 Dec 2022 at 10:08:11

Like (0)

Report

Re: Create a Logic function in a flow with 3 parameters

Hi @v-dezhili-msft ,

I am not using condition block instead applying all conditions inside append to string variable condition. I have attached a screenshot of the same. Here for one Project only one condition will be true and the other condition will be false. Whichever condition is true that respective column value it will take.

Screenshot (68).png
v-dezhili-msft Microsoft Employee on 02 Dec 2022 at 10:02:16

Like (0)

Report

Re: Create a Logic function in a flow with 3 parameters

Hi @Uthhra ,
You can use and() directly in condition action
Best Regards,
Dezhi
Sri 559 on 02 Dec 2022 at 09:41:04

Like (0)

Report

Re: Create a Logic function in a flow with 3 parameters

Hi @v-dezhili-msft ,
When all 3 conditions matches and becomes true it takes the specific value for the column from Share Point and send an mail in a HTML format.
For eg. If Project Method(Traditional) , Contract type(T&M) , Project type(Dev) matches it will take Schedule column value and if Contract type(FP) , Project type(Dev), Project Method(Traditional) it will take commitment column value.
v-dezhili-msft Microsoft Employee on 02 Dec 2022 at 09:33:14

Like (0)

Report
Re: Create a Logic function in a flow with 3 parameters

Hi @Uthhra

Are you trying to return something else when all three of your conditions are true?
You can try to change the formula to:

if(and(equals(items('Apply_to_each_4')?['Project Type'],'Dev-Enh_Upgr-Impl'),equals(items('Apply_to_each_4')?['Project Method'],'Traditional Development'), equals(items('Apply_to_each_4')?['Projectcontract'],'T & M')),'The value returned when true','the value returned when false')

Best Regards,
Dezhi