Unanswered

Conditon to read a Vlookup value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello All,

I am creating a flow where form details are added to a row in an excel table. Then using a vlookup in the table it results in a number being generate or being blank. I want to add a condition where if the number is present, email the respondent. If it is blank, email a different person.

My tests fail so far. I think the condition is reading the cell as being filled with the formula rather than the result which is blank.

Any help with this would be greatly appreciated. Below is a screenshot of what I have:

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

There are different ways you can check whether the value is null. Use the null expression or length() expression greater than zero. Check the run history and see what it is returning? Add the above mentioned conditions null or length.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Below is the failure when I tried length is greater than zero:
InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '21230': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#length for usage details.'.
And below is the failure using the null:
InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '21230': 'The template language function 'greater' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Null'.'.

If I use the column not equal to null, it always results in false.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Did you tried checking null

If that doesn't work then try with no value

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes I checked both of those. The problem is, the cell isn't technically empty. The VLOOKUP function is in the cell. I am trying to get the condition to read the result of the formula vs. the formula itself. So if I change the condition to null or empty, it will always show false because there is data in the cell. Is there any condition that will process the VLOOKUP function?

Was this reply helpful? Yes No