Sorry, we didn’t find that App – Canvas App on Model Driven Form
Hi Everyone, Today I did develop a small canvas app and have to show it in a section on Model Driven form (Account form). I have added a IFrame on the Model Driven Form and gave the URL of the Canvas App to IFrame. Published the form in Dynamics 365 CE and refreshed the Account page and clicked on the Tab where I have placed the Canvas App, it displayed as below. “Sorry, we didn’t find… Continue Reading...
Invalid type. Expected String but got Null or Invalid type, Expecting Object but got Null – Microsoft Flow/Power Automate
Hi Everyone, Today I was working on flows and all of a sudden flow started failing with the below error at Parse JSON step. “Invalid type. Expected String but got Null” However, was able to understand the issue after checking the input that was passed to Parse JSON step. One of the property value is coming as Null. The fix is easy, we just need modify the Schema of Parse… Continue Reading Gopinath’s Article on...
How to get the count of items in a Collection – Canvas App/Power Apps – Power Platform
Hi Everyone, Today I was working on CanvasApp and I have to show the count of the items in the collection on UI. This can be done easily by using the below formula. CountRows(CollectionName) I have given Text property of the label as below and here the result is showing the count. Check this post on how to get and show the Dynamics 365 CE records using flow on Canvas… Continue Reading Gopinath’s Article on their blog How...
Required properties are missing from object while parsing JSON in Power Automate or Microsoft Flow
Hi Everyone, Today I am working on a flow and received below error at ParseJSON Step. “Required properties are missing from object : property names” This error is coming as we have specified some of the properties as required in the Schema and as they are not given as an input to Parse JSON, the step is failing while validating the data with schema. To fix this, we have to edit… Continue Reading Gopinath’s...
Get the records from Power Automate (List Records) and display them on the Gallery – Power Platform – Dynamics 365, CDS, Power Automate and Canvas App
Hi Everyone, In this post, let’s try to understand the steps that are needed to get the data from Power Automate using Common Data Service List Records Action and show the same on the Canvas App Gallery. As a first step, let’s build Power Automate to get records from Dynamics 365. Take a trigger as a PowerApps as we would calling this flow from Canvas App. Add Common Data… Continue Reading Gopinath’s Article on...
Set Label Text on a Button Click or Select – Power Platform – Canvas Apps
Hi Everyone, I have started on PowerApps and as I am newbie on this, I am trying to understand the things clearly before we do. Today I got a requirement to set the label text to something onclick of a button, oh.. sorry.. onselect of a button(powerapps terminology :)). I thought, it would be the same way of the statement which we are so used and have written below statement… Continue Reading Gopinath’s Article on their...
The Solution ID is incorrect or missing. Add the correct Solution ID to the URL and try again – Dynamics 365 CE
Hi Everyone, Today I was getting the below issue when I tried to edit Model Driven App in Make.PowerApps.com (New UI for Solutions) and it is working absolutely fine in Classic Editor. “The Solution ID is incorrect or missing. Add the correct Solution ID to the URL and try again.” However, to understand more on this, raised a support ticket with Microsoft and continued with my R &… Continue Reading...
Display Components in Default Solution by Component Type in New Solution UI – Make.PowerApps.com
Hi Everyone, I was checking the default solution in new UI, I need to check flows we have in the system. I am very new this UI and it took time for me to understand how can get the list of components by component type. In Classic Editor, the left navigation pane helps to select the component and the canvas would show the selected component types. If you want to check the… Continue Reading Gopinath’s Article on their blog...
Make use of Terminate Action in Flow/Power Automate
Hi Everyone, Today I was talking to one my friends and he asked a question on how to stop the flow execution at a specified some point. I didn’t get his question for the first time when I heard. Here is the good explanation of it. Let’s say we have a flow that has more than 30 steps and we all know how often requirement changes. I am changing the existing flow and want to execute the… Continue Reading...
Release wave 2020 2 is on the way – Dynamics 365
Hi Everyone, We are yet understanding good amount of features that were released in Release Wave 1 2020 of Dynamics 365 and we have Release Wave 2020 2 on its way. July 8, 2020: Release plans availableLearn about the new upcoming capabilities for Dynamics 365 and Power Platform.August 3, 2020: Early access availableTry the new features and capabilities that will be part of the October… Continue Reading Gopinath’s Article...
Best Practice – Adding Comments in Power Automate/Flows
Hi Everyone, Today I was going through the settings of one of the Actions in Flow and have seen “Add a comment”. We all know the best practice of adding comments in all programming languages and it is the same in Flows as well. As a best practice, let’s put few words on what exactly we are doing in the comments. Hope this helps. —Happy… Continue Reading Gopinath’s Article on their blog Best Practice...
Power Platform Analytics – Common Data Service, Power Automate and Power Apps
Hi Everyone, Today I was going through Power Platform Admin Center and checked Analytics from the navigation. I remembered the days where we used to install Organization insights managed solution and check active/inactive users, storage usage, plugins success rate etc. Now, we don’t need any solution to install and there are lot more useful information to understand the system health… Continue Reading Gopinath’s...
Are we saying bye bye to Quick Find Views? Yes – Dynamics 365 CE
Hi Everyone, Today I was testing some functionality in Dynamics 365 CE Unified Interface and searched for an account, I remembered we have a view named as Quick Find and whenever we do search, the system used to apply the filters from Quick Find view and show the results accordingly. However, this has been in Unified Interface. When we search, the system honoring the view where we are,… Continue Reading Gopinath’s Article...
Get the Count of records in Flow or Power Automate – Dynamics 365 CE
Hi Everyone, Today I got a requirement to check the record count and do some operation if the count is greater than 1. We are very much used to these kind of checks in C# and just think if we need to the same in Flow. Here is the way to do. We just need to know one expression for doing it. I have a following Action of List Records from CDS connector and renamed it to… Continue Reading Gopinath’s Article on their blog Get...
Increase the limit of ExportToExcel in Dynamics 365 CE – MaxRecordsForExportToExcel
Hi Everyone, Today I was working with one of the users and they want to export more than 10000 records from Dynamics 365 CE. We all know that is the limitation in the system. Somehow, I remembered that I read saying that we can increase the limit and quick check has shown a way to do. There is a configuration for this and we can update in a supported way. MaxRecordsForExportToExcel… Continue Reading Gopinath’s Article on...
Cool feature in Visual Studio – Generate Class from JSON or XML
Hi Everyone, Today I was asked a question by one of my friends on if I know any easy way which can generate C# Class file if we give JSON as an input. And I don’t know anyway but certainly there should be an easy way to do the same. To my surprise, it turned to be a very easy one. Visual Studio has cool feature, copy JSON or XML to the clipboard –> Open any class file –> Edit –> Paste… Continue...
Collect and ClearCollect in PowerApps
Hi Everyone, In this post, will try to understand as much as possible on Collect and ClearCollect functions in PowerApps. Collect and ClearCollect functions are useful for when we want an in-memory store for data. They can save Collections and can be accessed from any screen in the App. Here is the syntax for the same. Collect(collectionName, Items)ClearCollecct(CollectionName,… Continue Reading Gopinath’s Article on their...
Text Control in PowerApps
Hi Everyone, It’s all about Text Control in PowerApps (Canvas App) today. As we all know, Text is a string. Below are main properties or events which we have to remember OnChange – When the state of the control changesOnSelect – When the taps the controlVisible Property – By definition, it takes bool. True – It shows the field on the form and we can use this property to show and...
Create Record in Dynamics 365 CE Using Power Apps and Power Automate (Flow)
Hi Everyone, This is my first post on Power Apps (Canvas App) and could be very basic to most of the people but it would helpful for the beginners like me. Login to Make.PowerApps.ComWe can directly create an App and Flows from the navigation as below but I would recommend to create a Solution first and then create App and Flow in that. Create a solution with the name as you wish… Continue Reading Gopinath’s Article on...
Failed during http send request – while adding flow to Canvas App
Hi Everyone, Today I was working with Flows and Power Apps (Canvas App). I have to invoke Flow from Canvas App button click and I was getting an error as below while add flow to Canvas App. “Failed during http send request” Spent good amount of time on understanding and it seems this is happening due to multiple reasons. One thing I came across was if you have a variable of Array… Continue Reading Gopinath’s...
Mention height and width in Percentage instead of Pixels – Modal Popups in Dynamics 365 CE – NavigateTo
Hi Everyone, Today a bug was created by the user saying the popup window is too small and we were using below code to show the HTML Webresource as a popup. var pageInput = { pageType: “webresource”, webresourceName: “WebResourceName” }; var navigationOptions = { target: 2, width: 400, height: 300, position: 1 }; … Continue Reading Gopinath’s Article on their blog Mention height and width in...
Preview Contact and Owner information by just hovering on the lookup – Dynamics 365
Hi Everyone, Today I was testing something on the trail instance and I just hovered on the Contact lookup and saw pop out window like below. I haven’t observed this so far. Somehow I am impressed with it as this is giving information to the users by just hovering. When you click on Show More button, the details are opened as a popup. I couldn’t find the form that is being… Continue Reading Gopinath’s Article on...
Multimedia Control in Dynamics 365 Customer Engagement
Hi Everyone, We all know visual presentation of anything is attracted first and if it is a video, that gives advantage. If we have a Video that is embedded on the Product record in the system that gives clear path for the sales person to explain the things. And yes, we can easily do that using Multimedia OOB Control. You just need to create a field of Single line of text and format as… Continue Reading Gopinath’s Article...
Number Input Control – Dynamics 365 Customer Engagement
Hi Everyone, One more good control which can be used in the place of any numerical or money field is Number Input. This gives flexibility to users to tap the plus and minus button to change a numeric value in increments you set. Just select the numerical or money field for which you would like to convert to Number Input –> Change Properties –> Add Control –> Select Number Input –>… Continue...
Auto-Complete Control in Dynamics 365 Customer Engagement
Hi Everyone, Today I was going through the Field properties and checked Controls tab. Just to understand more clicked on Add Control link and somehow Auto-Complete Control grabbed my attention. What is Auto-Complete Control? This control filters an item list as you type and lets you select a value from the drop-down list. For example, you can use this control to let users choose from… Continue Reading Gopinath’s Article on...
Save and Close not working on the forms in Dynamics 365 CE
Hi Everyone, Today I was working with HTML Webresource, we have some Hyperlinks on that. We have observed avery strange issue, Save and Close button on the from is not working on first click after we click on the hyperlink in the HTML Webresource and it works when we click for second time. Here is the sample source code that we had and if we remove the HTML webresource or if don’t click… Continue Reading Gopinath’s...
File and Image Data Type Fields in Dynamics 365 Customer Engagement
Hi Everyone, Today I was creating some fields as per requirement in Dynamics 365 Customer Engagement and I know that File Type was available quite sometime in CDS but it can used only via Canvas App. To make our lives exited, File Type is available on Model Driven App now. Along with this, we can create multiple fields of type image in single entity. Well there was Entity Image that has… Continue Reading Gopinath’s Article...
Filtering is getting better -Dynamics 365 CE
Hi Everyone, Today I was testing some functionality as per my requirement on home page grids and was applying some filters to see the right data. It seems the filtering has been bit improved in the latest version. I have observed two things. 1) Lookups – When you try to filter on column of type lookup, you will see the list as a drop down and that too very fast. Not sure what kind of… Continue Reading Gopinath’s...
Query CDS/Dynamics 365 data using SQL Query
Hi Everyone, You know A SQL data connection is available on the Common Data Service endpoint. Although I am a big fan of FetchXML which makes our lives easier as we don’t need to worry about backend things and our powerful Advance Find always helps us to frame Fetch XML in a right way. Sometimes(Debates with Salesforce Team as they always mention that they have SQL Workbench) even I felt… Continue Reading Gopinath’s...
Using SQL to Query CDS Data – Login failed: TDS protocol endpoint is disabled for this organization
Hi Everyone, I was exploring on preview feature on how can we connect SQL to Dynamics Data and while connecting to CDS received below error. “Login failed: TDS protocol endpoint is disabled for this organization.” Follow below steps to solve it. 1) Download the OrgDBOrgSettingsTool i.e. CRM2016-Tools-KB4046795-ENU-amd64 from here and run it. 2) Change CRM URL’s and… Continue Reading Gopinath’s Article on...
Create Email record in Dynamics 365 CE using JavaScript
Hi Everyone, I know this could be very simple as we are doing this from ages but somehow I couldn’t get this piece of code very easily. Code for creating email record using JavaScript in Dynamics 365 Customer Engagement. Important thing here to understand more on Activity Party Participation Type Mast. Go through Microsoft Docs for more information on the same. var activityParties =… Continue Reading Gopinath’s...
Show tooltips on Kendo Grid
Hi, Today I got an requirement to show the tooltips on each column of the grid. I was able to achieve it very easily by adding the below code but the tooltip was showing with black background. I had to invest sometime to understand the how styling for tooltip works. We can use CSS like below. $(“#grid”).kendoTooltip({ filter: “td:nth-child(2)”, //this filter selects… Continue Reading Gopinath’s...
Set fixed height to Kendo Grids
Hi, We all know how great Kendo Controls works and the most famous one among all the controls is Grid. Today l got an opportunity to work on Kendo Grid and my requirement was to set the Fixed height to the grid irrespective of the rows. Somehow I didn’t get the below piece of the code to make the grid fixed easily and adding it here so that it would help others. Just add the below to… Continue Reading Gopinath’s...
How to Get the AppId of Model Driven App in Dynamics 365 using JavaScript
Hi Everyone, Today I was working on something and we need to get AppId in JavaScript. We all know it is available on URL and we can get it from there but we cannot really depend on URL as it is generated by Product and it might change. After quick check, I found that we can easily get AppId using the below code. var globalContext = Xrm.Utility.getGlobalContext(); … Continue Reading Gopinath’s Article on their blog How to...
Resource not found for the segment – Power Automate
Hi Everyone, Today I was working with Power Automate and the requirement was simple on the update of the case status, we have to create an entry in the Custom activity entity. Obviously, this is simple and we don’t want this operation to be synchronous, hence we have chosen to do it using a Flow. After starting working on Flows for this requirement, I understand the real meaning of… Continue Reading Gopinath’s...
Common Data Service vs Common Data Service (Current Environment) – Power Automate
Hi Everyone, Today one of my team members asked on what are the difference between Common Data Service and Common Data Service (Current Environment) and why I always mention to use CDS Current environment connector. Here is the explanation I gave. There are 2 connectors available for CDS in Power Automate Common Data ServiceCommon Data Service (Current Environment) Well, in the… Continue Reading Gopinath’s Article on their...
How to Enable, Configure and Use Sales accelerator – Dynamics 365 Customer Engagement
Hi Everyone, Sales Accelerator is a preview feature and not meant for Production Use. Follow Microsoft Docs for officially confirmation the launch. “The Sales accelerator helps sellers in your organization increase their sales productivity and prioritize activities for the day through the work list available in Sales Hub app. A sales manager uses the sequence designer to create a… Continue Reading Gopinath’s Article...
Hide Related Tab on Form – Dynamics 365
Hi Everyone Today I have created an entity and was checking the configuration to rename the form name. While doing this, have found a setting to hide “Related” Tab on UCI. I still remember the discussions with Customers on explaining this Related tab saying we don’t have control on it :). Related tab is good to have when an entity has relationships with other entities but sometimes you… Continue Reading...
Enable/Disable Rich Text Editor for Notes on Timeline
Hi Everyone, Today I was checking System Settings to configure something and I found a setting to enable or disable Rich Text Editor for Notes on Timeline. Somehow I feel we don’t need a setting for this, who wants disable this wonderful feature. However, if anyone is looking to disable to Rich Text Editor check this out. Hope this helps. —Happy… Continue Reading Gopinath’s Article on their blog Enable/Disable...
Check the status on Solution Import – Dynamics 365 Customer Engagement
Hi Everyone, Certainly, everyone Dynamics 365 CE Consultant/Architect must have started importing the solutions and went for dinner, lunch, break or checked the mobile thinking the solution import would take some time. After they come back, the import might be still going on and at that time everyone would be eager to check what exactly the status of the import. Also sometimes, knowingly… Continue Reading Gopinath’s...
Open subgrid record as a Modal Popup in Dynamics 365
Hi Everyone, The most awaiting feature Modal popups are availabe in Dynamics 365 now and made our lives easier for many things, we are getting many requirements to open the records as a popup where we have control on the parent record and hence not loosing the changes. One of the requirement I heard today was opening the record as popup from Subgrid. Initially we thought there is no way… Continue Reading Gopinath’s Article...
Get Security Roles of the User – Dynamics 365
Hi Everyone, Today one of the Developer in my team was stuck with one issue and the issue was about validating users security roles and allowing the user to perform some operation. User was associated with only 2 security roles and the below line of code was giving 4 GUIDs. When we checked the code, whatever he was saying was correct. After few mins, we came to know that this line gets the… Continue Reading Gopinath’s...
Xrm.Navigation.openForm – Open the record with specific Business Process Flow
Hi Everyone, Today I got some strange requirement that to open the record by setting up to specific Business Process Flow on UI when clicked on the lookup from the child form. We need to understand multiple new things from doing this. 1) addOnLookupTagClick event – Refer this to understand more about. By this event, we can prevent the default behavior of the click event on lookup.2)… Continue Reading Gopinath’s...
Status of the Activities on Timeline is back with Dynamics 365 2020 Wave 1 Release
Hi Everyone, Today I was testing something on 2020 Wave 1 Release and you know, I am able to see the Status of the activities on the timeline. It was there on some older versions and suddenly disappeared. Not sure what happened and it was very hard to find what are the pending activities to take an action without status. And, now it is back. Thanks for fixing it. Hope this… Continue Reading Gopinath’s Article on their blog...
Environment Variables – Power Apps/Dynamics 365
Hi Everyone, I was going through the solution components today and found Environment Variables when clicked on New button after opening the solution. Explored little bit about it and here are the takeaways. From ages, we are using custom entities for storing configurations which might differ from environment to environment and using them in Plugins, Workflows, JavaScript and now… Continue Reading Gopinath’s Article on...
Advance Filtering in Dynamics 365 2020 Wave 1 Release
Hi Everyone, Today I have doing some testing, observed a filter just beside Search box on the Grid and when I clicked it has open a popup as below. Played little bit with that and you know it works like a charm. It allows us to build simple to complex filters without even opening Advance Find You can add more filters by selecting a column to filter on, then choosing an operator… Continue Reading Gopinath’s Article on their...
Be careful while updating Dynamics 365 CE record with Multi select field using Microsoft Flow/Power Automate
Hi Everyone, I was exploring Microsoft Flows today and was trying to create and update records with different data types. While testing observed that Multi Select values are getting overridden and it is understandable as well. However, we might have to take care it while impletmenting. For example, if I am updating a record for which Multi select value is already selected and I would… Continue Reading Gopinath’s Article on...
Notes Analysis from Sales Insights – Dynamics 365
Hi Everyone, Today I was going through Sales Hub and enabled Sales Insights to understand it more. As part of the Dynamics 365 Sales offering, only some of the basic features are available for free. Somehow, I feel Notes Analysis is a use full feature. It requires you to have a Sales Insight license. You can enable a free trial of this app though, to check how it works. Enable Sales… Continue Reading Gopinath’s Article on...
Share a model-driven app with Power Apps – Dynamics 365
Hi Everyone, Shaing an App to the users is much more than easier before with PowerApps new UI. Previously, it was a lengthy process which required several steps. This has been streamlined into a single panel now. As we all know that Sharing a Model-Driven app requires two steps. 1) Associate one or more security roles with the App.2) Assign the Security role to users. Here are the… Continue Reading Gopinath’s Article on...
Save is always visible in the command bar on edit forms – Dynamics 365 Release Wave 1 2020
Hi Everyone, Today I was just going through Sales Hub and found that Save and Save & Close buttons are not hidden even though Auto Save is enabled. In the previous version of Dynamics 365 I remember we had multiple discussions on the same (I hope everyone had :)) that Save button was not visible on the Command bar. Even though Auto Save is enabled in the system, it is always good to… Continue Reading Gopinath’s Article...