do nothing in if function

(2) Share

Report

Posted on by petergriac

Hi all,

Does anyone know how to write 'do nothing' in if statement when the condition is not true?

example if ( condition, 'do an action', 'do nothing')

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (1)

NPrice99 1,302 on at

Like (3)

Report

Hi

Just put false in the false part of the If STatement

Regards

Nigel

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft on at

Like (6)

Report

Hi @petergriac,

If you want to do nothing when the condition is not true, you just need to leave the If no branch of the Condition blank, do not add any actions in it.

And you could add actions that you want to to do in the If yes branch of the Condition.

Best regards,

Alice

Was this reply helpful? Yes No
petergriac 72 on at

Like (0)

Report

Thanks,
This works.

Regards,
Peter

Was this reply helpful? Yes No
BSacchini 6 on at

Like (1)

Report

In my case this does not work. It throws my an error

"ActionFailed. An action failed. No dependent actions succeeded"

Any ideas how to work around this error?

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Fix the dependent actions, I guess?

Was this reply helpful? Yes No
kgreen8790 189 on at

Like (0)

Report

How can we use an expression to signify "do nothing"? I can't use the gui condition connector due to checking the condition inside of a column for "update a row in a table connector"

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Hi @kgreen8790,
could you please rephrase?

Was this reply helpful? Yes No
kgreen8790 189 on at

Like (3)

Report

In the originally accepted solution the author stated to leave the "No" window blank to solve the "do nothing if false". Due to my use case I can not use the "Condition" connector in the power automate GUI. I'm wondering if there is a way to achieve the same result with a written expression. Currently if I leave the third parameter blank on my written if statement expression I get an error saying "if requires 3 parameters, only received 2". I've tried if(equals(item(), 'X'), 'Do X', false) but in this instancte the flow actually places the word false on my spreadsheet (which is what I'm using the condition for). If I try if(equals(item(), 'X'), 'Do X',) I get the beforementioned "requires 3 parameters only received 2" error. So, in closing is there a way to express an written if statement where the false comparative simply takes no action?

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (1)

Report

Try to use something like tis:
if(equals(item(), 'X'), 'Do X', null)

Was this reply helpful? Yes No
J Morris 28 on at

Like (0)

Report

I am having the same issue. I have tried the following expressions with a excel data source and writing to D365. Both still clear out the data in D365. I don't want to create multiple conditions in the flow to accomplish this as I have a lot of fields that needs this logic. I have used this same expression with a Microsoft Form data source it is still works. But when I switched to an excel data source it no longer works.
if(empty(outputs('ListRows')?['Main Phone']),' ' , outputs('ListRows')?['Main Phone'])
if(empty(outputs('ListRows')?['Main Phone']),null , outputs('ListRows')?['Main Phone'])

Was this reply helpful? Yes No