Parse JSON schema loosener
A schema generated from one sample payload assumes every future payload will look exactly the same. The first time a field arrives empty, Parse JSON fails with Invalid type. Expected String but got Null, or with Required properties are missing from object when a field is left out altogether.
This tool removes every required array and adds null to every property type, so the action accepts the data and the rest of your flow can deal with the gaps.
JSON Schema Loosener
PASTE AN EXISTING SCHEMA
MAKE PARSE JSON RESILIENT TO MISSING OR NULL VALUES
Removes every "required" array and allows null on every property type, so the action stops throwing when a field is missing.
How to use it
- Copy the schema out of your Parse JSON action and paste it in.
- Copy the loosened schema back into the action.
- Fields can now be empty, so use
coalesceor a condition later in the flow wherever a missing value matters.
Nothing you type here is sent anywhere. The tool runs entirely in your browser.
More free tools
EVERY TOOL RUNS IN YOUR BROWSER
NO SIGN-IN, NOTHING STORED
Power Automate expression builder
Pick a function, fill in the values, copy a working expression.
Trigger condition and filter builder
Conditions in, a trigger condition or Power Fx Filter formula out.
formatDateTime generator
Pick a date source and a format, get the formatDateTime expression.
SharePoint column formatting generator
Conditional background colour for a list column, as ready-to-paste JSON.
SVG to Power Apps image converter
Paste SVG markup, get a data URI for the Image property.
Parse JSON schema generator
Paste a sample payload, get the schema for a Parse JSON action.
Adaptive Card builder
Title, body and Approve / Reject buttons, as card JSON for Teams.
Flow error handler (Try / Catch)
Run-after settings, error expression and alert body for a Try / Catch scope.
HTML email table styler
Column headers and a colour, as an inline-styled email table.
OData filter query builder
Conditions plus $select, $orderby and $top, as an OData query.
FetchXML builder
Dataverse's own query language, for List rows or Advanced Find.
Browse every tool →
All twelve free Power Platform tools on one page.