Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Power Automate - Custom Connector - NULL values are being dropped in the flow from the schema

(0) ShareShare
ReportReport
Posted on by 200

Hi,

 

I have a custom connector that retrieves data from an API.

The API correctly returns all the required fields.

 

When i call this custom connector using Flow, the data is returned, HOWEVER, if one of the values contains a NULL it does not appear in the schema, which causes the flow to break further down.

 

Example:

Source from the custom connector:

 

"UserId""24XILTQNtfUu4VwsfLZN3A2",
    "Title""Test Course",
    "CourseId""G8ZeXsFgng41",
    "Score""",
    "Result""Complete",
    "Type""Course Completed",
    "AchievementId"64881430,
    "CertificateId"null
  }
 
what is returned from the custom connector using Flow :
 
"UserId""24XILTQNtfUu4VwsfLZN3A2",
    "Title""Test Course",
    "CourseId""G8ZeXsFgng41",
    "Score""",
    "Result""Complete",
    "Type""Course Completed",
    "AchievementId"64881430
}
 
As you can see , the "CertificateId" from the JSON is missing.
 
Is it normal behavior for flow to drop any json tags with null from a custom connector?
 
If so, how can i get around this??
 
swagger definition below:
DragonLord_0-1607596499811.png

 

 

 

  • Verified answer
    DragonLord Profile Picture
    200 on at
    Re: Power Automate - Custom Connector - NULL values are being dropped in the flow from the schema

    i managed to get around this by testing if the "missing" JSON tag had a length of > 0.

    its a crap solution but it seems to work for now 😞

  • MJain Profile Picture
    2,450 on at
    Re: Power Automate - Custom Connector - NULL values are being dropped in the flow from the schema

    @Anonymous ,

    Can you please share your flow screenshots ?

     

    Thanks

  • Community Power Platform Member Profile Picture
    on at
    Re: Power Automate - Custom Connector - NULL values are being dropped in the flow from the schema

    I have been using your mention code and want to implement it on my site of https://canoesurfer.net/ but it was not working and I was really worried about that and could not found anyway that how can i solve this.

  • MJain Profile Picture
    2,450 on at
    Re: Power Automate - Custom Connector - NULL values are being dropped in the flow from the schema

    Hi @DragonLord ,

     

    Use Parse Json action with the content you have provided as you mentioned the custom connector is not sending certificate :

    {

    "UserId""24XILTQNtfUu4VwsfLZN3A2",
        "Title""Test Course",
        "CourseId""G8ZeXsFgng41",
        "Score""",
        "Result""Complete",
        "Type""Course Completed",
        "AchievementId"64881430,
        "CertificateId"null
      }
  • DragonLord Profile Picture
    200 on at
    Re: Power Automate - Custom Connector - NULL values are being dropped in the flow from the schema

    does not work unfortunately, the JSON tags are being removed by the custom connector, so even using PARSE JSON does not recognise them.

  • MJain Profile Picture
    2,450 on at
    Re: Power Automate - Custom Connector - NULL values are being dropped in the flow from the schema

    Hi @DragonLord ,

     

    After the response is received from custom connector use Parse JSON and use the one which has all fields. Add null in the schema as follows:

    ["string","null"] to handle null values.

     

    Thanks

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow