Power Automate – Get schema of a Power App collection for Parse JSON action

Step 1:

In a blank canvas Power App, insert a button named Button1. Change the following properties:

Text property

"Create Sample Collection"

OnSelect property

ClearCollect(collMyCollection,
Table({City:"Jakarta",Population:10560000},
{City:"Manila",Population:1850000},
{City:"Singapore City",Population:5640000},
{City:"Kuala Lumpur",Population:1980000})
)

Step 2:

Insert another button named Button2. Change the following properties:

Text property

"Convert Collection To JSON"

OnSelect property

Set(varJSON,JSON(collMyCollection,JSONFormat.Compact));

Step 3:

Insert a text label named Label1. Change the following properties:

Text property

varJSON

Step 4:

Insert another button named Button3. Change the following properties:

Text property

"Copy Code"

OnSelect property

Copy(Label1.Text)

Step 5:

Activate play mode. Click on the ‘Create Sample Collection’ button. This will create our collection. In your scenario, you can replace this one with your collection. Note that when clicking the button there is no indication that the collection has been created.

Step 7:

Click on the ‘Copy Code’ button. This button simply copies the text in the label to your clipboard.

Step 8:

Go back to your flow where the Parse JSON is. Click on ‘Generate from sample’ button.

Step 9:

Since the JSON text is already copied to your clipboard, paste the data into the box. Select the ‘Done’ button afterwards.