ParseJSON in Power Apps (JSON to Power Fx)

Turn a JSON sample into ready-to-paste Power Fx: ParseJSON with Type(), field access with Set() and ClearCollect/ForAll for collections.

When a flow returns JSON (for example through Respond to a Power App or flow), you read it in Power Apps with ParseJSON() (tip 158). The tool creates three variants, each a complete formula with ; between statements: field access with the right casts, a Type() definition with tables in square brackets and a ClearCollect() with ForAll() that also maps nested objects and arrays.

Open ParseJSON Converter

Free. You enter your email address once, then all tools are unlocked. Your data is processed locally in your browser.

How it works

Paste a JSON sample (e.g. the flow response).
Set flow name, flow output, root variable and collection name.
Copy the Power Fx and paste it, for example, into OnSelect.

Example: typed ParseJSON

Set(
    gblResp,
    ParseJSON(
        MyFlow.Run(...).jsonresult,
        Type(
            {
              customer: { name: Text, vip: Boolean },
              orders: [ { id: Number, total: Number } ]
            }
        )
    )
);

Example: array into a collection

ClearCollect(
    colResponse,
    ForAll(
        Table( gblResp.orders ),
        {
            id: Value( ThisRecord.Value.id ),
            total: Value( ThisRecord.Value.total )
        }
    )
);

Frequently asked questions

Is the tool free?

Yes.

Is my JSON uploaded?

No, the conversion runs entirely in your browser.

What is the difference between ParseJSON with and without Type()?

Without Type() ParseJSON returns a Dynamic value that you cast per field (Text, Value, Boolean, DateValue). With Type() you get strongly typed records without single casts.

How do I write a table in Type()?

With square brackets and exactly one record, for example orders: [ { id: Number } ]. The Table() function is not used inside Type().

How do I get JSON into a collection?

The tool creates ClearCollect() with ForAll() over Table(...). Nested objects become records, arrays an inner ForAll.

Do I need a premium license?

No. ParseJSON and Respond to a Power App or flow are standard, as long as no premium connector is involved.

Related tips

All tips in the archive