web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Conditon to read a Vlo...
Power Automate
Unanswered

Conditon to read a Vlookup value

(0) ShareShare
ReportReport
Posted on by 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:

JMH0601_0-1603469097421.png

 

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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.

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Anonymous 

     

    Did you tried checking null

     

    image.png

     

    If that doesn't work then try with no value

     

    image.png

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard