How to handle "null" value in JSON when developing the Custom Connector of the Power Platform and Automate?

Question

I'm developing the Custom Connector and the Automate on the Power Platform.

Let's say that:

• The Automate flow receive the JSON via the custom connector
• The JSON response data has over hundreds of properties
• The JSON may have "null" value on some of properties, and they cannot be predictable what property have the null value
• According to that reason, I have to handle the null value with the Custom Connector

To avoid error, what kind of method can I have with developing the connector?

FYI: I found the Microsoft's document, but the below way cannot be used because of the reason I wrote above.

https://support.microsoft.com/en-us/topic/getting-errors-with-null-fields-d0a36825-72eb-bd78-dcc0-26018e8a1986

Answer 1

Hi @Takeshi Nick Osanai ,

AFAIK Power Platform and Power Automate is currently not supported in this Microsoft Q&A platform. It's better to reach out to dedicated forum over here.

Answer 2

Hi @KrishnaG-MSFT ,

Thank you for your notification.
I will repost my question to that forum.