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 / How to handle "NaN" va...
Power Automate
Answered

How to handle "NaN" values in JSON array

(0) ShareShare
ReportReport
Posted on by 136

Hello everyone.

 

I am trying to check the condition for "NaN" values in JSON array. After that I want to skip that record if contains "NaN" value.

Exp.

{
  "Customer""Test",
  "Time 1""NaN",
  "Time 2""0,33"
}
I have already tested a condition such as: (Outputs referirng to Timer 1)
NickFot_0-1698396496708.png

But none of them seem to work.

Any advice appreciated. Thank you.

Best regards,
Nick

Categories:
  • Verified answer
    rzaneti Profile Picture
    4,487 Super User 2026 Season 1 on at

    Hi @NickFot ,

     

    From my end, I've tested the condition with "NaN" (without quotes) and it worked fine. Another option that also worked is to set the expression string('NaN').

     

    rzaneti_1-1698405639544.png

     

    rzaneti_0-1698405629633.png

     

    I know that it is kind of a repetitive method, as "NaN" should be already a string, but let's see if it works for you 🙂

     

    Let me know if it works for you or if you need any additional help!

     

    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Solved.
    If this answer helps you in any way, please give it a like.

    http://digitalmill.net/ 

  • EmadBeshai Profile Picture
    806 Moderator on at

    Hi @NickFot ,

     

    Please add at the left side of the condition the below expression after filling it with your inputs 

    contains(<Your Json>,'NaN')

    and at the right side of the condition please true and the operator is " Not Equal"

     

    If this post helps you with your problem, please mark your as Accepted Solution.
    If you like my response, please give it a Thumbs Up. 

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 227 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 221 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 132

Last 30 days Overall leaderboard