Answered

IF condition for value in cell

(0) Share

Report

Posted on by slambos

I wanted to have an "IF" condition that checks if the "Matched with" column in my excel sheet has a value inserted or it's blank. That value will be different for each row and I want the email to be sent only if there a value in the "Matched with" column for each row. How can we create this IF condition?

This is what I have so far but it does not seem to work.

All responses (4)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report

Re: IF condition for value in cell

Hi @slambos,

Do you want to send an email if the 'Matched with' field is not blank?

Please configure the condition as below:

Note that you should just keep the 'Matched With' field in the left tab of the condition and write the null in the expression bar of the right tab of the condition and click the update button.
devendraVelegan 72 on at

Like (0)

Report

Re: IF condition for value in cell

@slambos : sorry, while adding the expressions, please use the dynamic content option so the expression gets resolved.
https://www.alanps1.io/power-platform/flow/flow-so-where-has-edit-in-advanced-mode-gone-on-condition-actions/
slambos 13 on at

Like (0)

Report

Re: IF condition for value in cell

I don't have the "Advanced mode" option. I tried to do it this way instead but it did not work. @devendraVelegan
devendraVelegan 72 on at

Like (0)

Report
Re: IF condition for value in cell

@slambos Please refer to the example below.
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#empty
After the action List rows present in a table, add a condition with the following code in Advanced mode:
@equals(empty(items('Apply_to_each')?['Matched with']), bool('True'))