All ToolsJSON to ClearCollect

JSON to ClearCollect

Paste a JSON array or object and get a ready-to-use Power Apps ClearCollect() formula you can drop into your app.

Collection Name

JSON Input

Power Apps Formula

ClearCollect(myCollection,
  {
    id: 1,
    name: "Alice",
    role: "Admin",
    active: true
  },
  {
    id: 2,
    name: "Bob",
    role: "Member",
    active: false
  }
);

How to use: Copy the formula above, open your Power App, navigate to App.OnStart or a button's OnSelect, and paste. The collection will be populated when the action runs.