Invalid type. Expected String but got Null or Invalid type, Expecting Object but got Null – Microsoft Flow/Power Automate

Hi Everyone,

Today I was working on flows and all of a sudden flow started failing with the below error at Parse JSON step.

“Invalid type. Expected String but got Null”

However, was able to understand the issue after checking the input that was passed to Parse JSON step. One of the property value is coming as Null.

The fix is easy, we just need modify the Schema of Parse JSON.

instead of “type”: “string” make it as “type”: [“string”, “null”] to handle null values.

Hope this helps.


Happy 365’ing
Gopinath.

One thought on “Invalid type. Expected String but got Null or Invalid type, Expecting Object but got Null – Microsoft Flow/Power Automate

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s