Power Fx function
JSON — Power Fx function reference
Serialize a value to JSON.
Syntax
powerfx
JSON( Value [, Format ] )
Examples
powerfx
JSON(colCart, JSONFormat.Compact)
→ JSON text
powerfx
JSON(colCart, JSONFormat.Compact)
powerfx
JSON({Name: txtName.Text, Age: Value(txtAge.Text)})Common mistakes & gotchas
- Format defaults to including type/metadata annotations unless you pass JSONFormat.Compact — most integration scenarios (sending to a Flow or REST API) want Compact for plain, standard JSON.
- Binary fields (attachments, images) are omitted by default and need JSONFormat.IncludeBinaryData explicitly, a common reason an exported payload is missing expected data.
Related Power Fx functions
From Data conversion