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:
I have the same question (0)
  • Verified answer
    rzaneti Profile Picture
    4,456 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

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
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard