Posts

Showing posts from October, 2023

Pagination in canvas app for Data Table.

Image
Hello Guys, In our previous  blog   we have seen how to display json data using Data Table. Today we will see how to implement pagination for Data Table in canvas app. 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 canvas app which we were using in our previous blog. As you can see we have our canvas app which is displaying rows. Now open the canvas app in Power Apps and select main screen and write below formulas: Set(AccountID,GUID(First([@ModelDrivenFormIntegration].Data).ItemId)); Set(FlowJson,ContactListFlow.Run("",AccountID)); ClearCollect(colDocument,ForAll(Table(ParseJSON(FlowJson.contacts)),{FullName:Text(ThisRecord.Value.FullName), Phone:Text(ThisRecord.Value.Phone),Email:Text(ThisRecord.Value.Email)})); UpdateContext({varPerPageRows:5}); UpdateContext({varPageCtr:1}); UpdateContext({varTotalPage:If(Mod(CountRows(colDocument),varPerPag

Displaying json data using DataTable in Canvas App.

Image
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

Calling power automate flow from canvas app.

Image
  Hello Guys, In our previous  blog   we have seen how we can pass parameters to canvas application from model driven app. Today we will see how we can call power automate flow from canvas app. 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 canvas app. As you can see we have already displayed canvas app. Now we will create one power automate flow which will return contacts based on account GUID. Open the canvas app and click on power automate flow icon as shown below: Click on create new flow and select create a flow. Specify details as show above. Now add a new step and initialize a variable as shown below:  Click on Ask in PowerApps. This will generate a variable which we can use from canvas app. We will use this AccountID which will be passed from canvas app to power automate flow.  Now add a new step which will be List. Here we will be retrieving cont

Passing parameter in embeded canvas application.

Image
Hello Guys, In our previous  blog   we have seen how we can embed canvas app in model driven application. Today we will see how we can pass parameters to canvas application from model driven app. 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 canvas app which we have created in our previous blog. As you can see we have embedded our canvas application in a model driven app. Now we want to access some data of model driven app. For example we want to display Account Name in canvas application or we want to use account GUID which we can use to query other columns in canvas application.  To achieve this open the Account Form in classic mode. As you can see we have Document Number column. Now go to the properties of this column and click on control tab and select canvas app. Now click on customize button which will open a new tab as shown below: Now here you ca

Embed canvas app in Model driven application.

Image
Hello Guys, In our previous  blog   we have seen how we to create range control which can be used to provide Age value in D365 field. Today we will see how we can embed canvas app in model driven application. 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. First of all we will be creating one canvas app. Follow below steps. Go to  https://make.powerapps.com  and select your environment. As you can see we have selected our environment. Now click on Create ->Blank App -> select Blank canvas app and click on create. Specify details as shown above and click on create. It will create your canvas app.  Now design the app as per your requirement and save the app. So our app is ready. Now we will use the same app in model driven app. We will display this app on Account entity. To achieve this we will first create one column of single line text as shown below: Now open the Account form and a