Error in expression

[frixel]

Hi,  

What goes wrong with the expression below?

if(equals(item()?['Ruleset_3'],'1'),'This text',add(add(int(item()?['Year']))),'')

[yashag2255]

@frixel Um no! I meant that when you run the flow, you get the flow run history and you can see what each action has. So Can you run this flow and from the run history share screenshots of the variables (set variable actions) and the conditions?

Thanks, 

[frixel]

This is what you mean?

[yashag2255]

Hi @frixel , Yes. In the second screenshot, can you expand the set variable so that I can see the error? 

Thanks, 

[frixel]

Hi @yashag2255 

[yashag2255]

@frixel Can you share the formula that you are using in the set variable action? In the Initialise Variable Actions, what is the value that you have provided? If there is no value over there, please add a '0' (without the quotes). This flow is failing because the add function is not getting the values properly. 

Hope this Helps!

[frixel]

Hi @yashag2255 

You mean this part with this formule?

[yashag2255]

Hi @frixel 

Were you able to resolve? Can you please share any progress you made so far on this? That way we can have a look and work on assisting you better with this. 

[v-lin-msft]

Hi @frixel,

Your column names are L, M, R, not column_L, column_M, column_R.

So you should change the code:

add(add(item()?['column_L'],item()?['column_M']),item()?['column_R'])

into

add(add(item()?['L'],item()?['M']),item()?['R'])

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

Hi @v-lin-msft @yashag2255 

Thanks for your support.

Below the Flow as I have it now.

No errors in the Flow but the outcome (mail) is incorrect.

I now get email 8x, also for 1007 & 1008 while there are not a 1 in the columns.
Also, the value from the columns L-M-R and N-O-S does not appear in the mail. (ResultOfLMR)

[yashag2255]

Hi @frixel 

Can you please share the datatype of each excel column: 

Year, Period, Ruleset_1, Ruleset_2, L, M, R, N, O, S

[v-lin-msft]

Hi @frixel,

You should set the condition 2 in your flow as one condition OR the other one satisfied your purpose, not AND.

And you should put the action Send an Email into the IF YES box, not under the action of Condition One. So that you will not receive 8 emails, just 6 emails.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

[frixel]

hi @v-lin-msft  @yashag2255 

i changed the things from v-lin-msft and than i have NO mails.

[v-lin-msft]

Hi @frixel,

Could you share the detail of the flow run to check the value of Ruleset_1 and Ruleset_2?

And to avoid the value confused, you should empty the value of ResultOfLMR and ResultOfNOS after the action Send an email, cause your flow configuration has changed:

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

Hi @v-lin-msft @yashag2255 

You mean this?

[v-lin-msft]

Hi @frixel,

No, the output of the action list rows present in a table, please show us the value of Releset_1 and Releset_2.

[frixel]

Hi @v-lin-msft @yashag2255 

This one?

[v-lin-msft]

Hi @frixel, 

Your configuration of condition 2 is like this, right?

If yes, you could have a try to change the other way,

length(item()?['Releset_1']) is not equal to 0;

length(item()?['Releset_2']) is not equal to 0;

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[frixel]

Hi @v-lin-msft 

When i try to put this here i have this error

[v-lin-msft]

Hi @frixel,

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.