Displaying json data using DataTable in Canvas App.

Hello Guys,

In our previous blog we have seen how we can call power automate flow from canvas app. Today we will see how to display json data using Data Table.

Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends.

We will be working with the same example which we were using in our previous blog.

As you can see in our last blog we have displayed json data in a Text Box control. Now we will use the same json data.

Delete the textbox control and label control. Once done select the Main Screen and write below formula:

Here we are using ClearCollect method which is used for creating collection.

ForAll method for iterating the table data and converting them into collection.

Table method for converting json into Table format.

Now we will insert one datatable from insert menu.

As you can see we have inserted one table. Now set its items or Data Source property to colDocument. Once done, click on Edit fields and add all the fields.

Save the changes and refresh the account record on model driven app.

As you can see our json data is now properly displayed as data table.

Hope it helps...