Thursday, 16 July 2020

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.

No comments:

Post a Comment