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 / Validate null entry in...
Power Automate
Answered

Validate null entry in returned value

(0) ShareShare
ReportReport
Posted on by 176

Hello,

 

In a condition check, an empty result is being returned liked this:

 

{
  "value": []
}
 
How can I configure this as a null return to make my condition functional? Just adding null to the expression doesn't do it. Thanks!
 
Screen Shot 2020-09-21 at 2.36.57 PM.png
 
 
Categories:
I have the same question (0)
  • yashkamdar Profile Picture
    1,044 on at

    Hello Team,

     

    Well, using the Empty expression is always always better than the NULL.

     

    Let me show you how to achieve this, it is fairly simple.

     

    Step 1 - Create a COMPOSE action and load it with your Value

     

    yashkamdar_1-1600754341456.png

     

     

    Step 2 - Condition to Check whether the COMPOSE action is null/empty (in short has some data or not)

     

    The Expression that you need to use is as below-

     

    empty(outputs('Compose')) is equal to True

     

    yashkamdar_2-1600754391949.png

     


    Now the condition checks if the Compose action (that is currently holding your dynamic content) is having some data or is Empty/Null.

     

    If it is Empty it will give out True, if not it will give out False.

     

    See output below-

     

    yashkamdar_0-1600754310316.png

     

     

    This is always simple to execute using the Empty expression, never try to implement NULL, it is not a good idea and does not always give valid results, whereas with Empty results will always be spot on.

     

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

  • ryan2k Profile Picture
    176 on at

    Assuming I followed your example correctly, that doesn't seem to work

     

    Screen Shot 2020-09-22 at 9.02.12 AM.png

  • Verified answer
    yashkamdar Profile Picture
    1,044 on at

    Hello Team,

     

    Noooooo, do not enter the entire thing in the COMPOSE action, just the value, the same like you entered earlier.

     

    There is no need to enter the entire array as is, you need to just populate the Value parameter from that entire body.

     

     

    yashkamdar_0-1600787394837.png

    Okay try this out -

     

    Just change your existing expression  to -

     

    empty(outputs('Value')) is equal to True

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

  • ryan2k Profile Picture
    176 on at

    Had to play with it some more, but got it working using the Compose feature. Thanks!

  • yashkamdar Profile Picture
    1,044 on at

    Hello Team,

     

    I feel so glad that the issue is now resolved and I was able to help you out with some insights.

     

    Super awesome, have a great day ahead !!!

     

     

  • Kamacete Profile Picture
    160 on at

    Hi,

    I'm trying to send an email when I have data on one worksheet. When that worksheet is empty, no email has to be sent.

    I have tried the example above, but something it's not working for me, can you please help me?

    2023-01-30_170902.png

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 442

#2
Vish WR Profile Picture

Vish WR 328

#3
David_MA Profile Picture

David_MA 268 Super User 2026 Season 1

Last 30 days Overall leaderboard