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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need help in Parsing J...
Power Automate
Unanswered

Need help in Parsing Json in Power Automate Desktop

(0) ShareShare
ReportReport
Posted on by

Hi Everyone, 

I'm trying to parse a Json but i'm getting error when the value is null, if it is having data means it is working. Below is my sample Json.

 

{"totalSize":1,"done":true,"records":[{"attributes":{"type":"Case","url":"/test service"},"Sales_Number":null,"Sales_name":null,"Sales_Email":null,"Sales_Contact":null,"City":null,"Pincode":560000}]} 

 

Example : Pincode have value now so it is returning me the value. If in case it is null then it is throwing error like - Currentitem doesn't have a property Pincode.

 

Is there any way that we can make the code to work for null values also. Except Pincode all are null values. So it is throwing me error. If it have value then it works. 

Please suggest me the solution.

Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @PrathapReddy1 

     

    Could you share the screenshot of the flow on how you are trying to parse it in Power Automate desktop ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • CU06020423-0 Profile Picture
    on at

    Hi @Nived_Nambiar sorry i didn't noticed this message. Morning i will share my flow screenshot.

  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @PrathapReddy1 

     

    Just wanted to confirm, you are doing this in Power Automate Desktop right ?

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • CU06020423-0 Profile Picture
    on at

    Hi @Nived_Nambiar   Yes, I'm using Power Automate Desktop

     

    PrathapReddy1_0-1707716091468.png

     

    In Display Message I'm using this .

     

    %CaseFieldsCurrentItem['Pincode']%
    %CaseFieldsCurrentItem.Sales_Number%

  • CU06020423-0 Profile Picture
    on at

    Hi @Nived_Nambiar   Can you help me where i'm doing wrong in this code or how can i handle even if the field is Null.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard