Power Fx function
ParseJSON — Power Fx function reference
Parse JSON into an untyped object.
Syntax
powerfx
ParseJSON( JSONText )
Examples
powerfx
ParseJSON(txtPayload.Text)
→ Untyped object
powerfx
ParseJSON(txtApiResponse.Text).status
powerfx
Value(ParseJSON(txtPayload.Text).total)
Common mistakes & gotchas
- Index fields then coerce with Value/Text/Boolean — untyped values are not usable directly.
- ParseJSON returns an "untyped object" — its fields cannot be used directly in typed contexts (arithmetic, concatenation, gallery binding) without explicit coercion via Text(), Value(), Boolean(), or Table().
- An array field needs Table(ParseJSON(x).items) to become a usable Power Fx table before you can ForAll/Filter/bind a gallery to it.
Related Power Fx functions
From Data conversion