-
Continue reading →: Power Apps | Unable to query Canvas App using CDS WebAPI
In my Power Apps Environment I have the following ‘Hello World’ Canvas App. When I query ‘Canvas App’ entity using Web API from same Environment, there were no Canvas App records returned. Reason: If you create a Canvas App from ‘Apps’ tab outside of solutions or imported any App to…
-
Continue reading →: Power Platform Admin Analytics
In previous Dynamics versions, with the help of Organization Insights, available as a preferred solution from AppSource, we can get the organization level insights such as No of Active Users, API Calls, etc. Now these analytics can be viewed right from the Power Platform Admin Center with no need of…
-
Continue reading →: Microsoft Teams and PowerApps – Project Oakdale
Project Oakdale, a new built-in low-code data platform for Teams that provides enterprise relational datastores with rich data types to Teams users, is now in public preview. Solutions built with Power Platform can be easily published to the Teams app store and can be used off the shelf or customized…
-
Continue reading →: [Code Snippet] Using Microsoft.Pfe.Xrm library
Pfe.Xrm library allows us to submit a bunch of XRM requests as batches (using ExecuteMultipleRequest) and execute them in parallel. In this article, lets see how to use Microsoft.Pfe.Xrm library with a simple ‘Retrieve Request’. What is Microsoft.Pfe.Xrm library? Contains a set of common components for building solutions using the…
-
Continue reading →: Power Apps | Custom connector | User does not have an entitlement to use PowerApps
From the Dynamics trial instance, while registering a Custom Connector, encountered following issue. Reason: Error message states clearly, that the User who is trying to register ‘Custom Connector’ does not have ‘Power Apps’ license. By default when you subscribe for trial , Dynamics only grants the ‘Dynamics 365 Customer Engagement…
-
Continue reading →: SQL SERVER | Merge Statement | The insert column cannot contain multi-part identifiers
Other day while executing SQL ‘MERGE’ statement on 2 tables, I ran in to following error. The insert column list used in the MERGE statement cannot contain multi-part identifiers Before we understand the reason and fix for this error, lets get the basics of ‘MERGE’ statement. ‘MERGE’ statement: ‘MERGE’ statement…
-
Continue reading →: Working with JSON data in SQL Server
In this article, lets see how to work with JSON data in SQL Server using SSMS. Following features will be covered in this article. Format SQL table data in JSON format (Using FOR JSON PATH clause) Store JSON data in SQL table Query JSON data in SQL server (Using JSON_VALUE…
-
Continue reading →: Power Apps | CDS | Track deleted records using ‘Change Tracking’
For unversed, Change Tracking in CDS allows data to be synchronized by detecting what data has changed since the data was initially extracted or last synchronized. Its useful in Integration scenarios, where you have to keep data between CDS and external systems in sync. Assume that your customer has a…
-
Continue reading →: Power apps – Model driven app – Excel import not working
Other day, when we copied one of the Environments to another and tried to import csv file using ‘Excel’ import feature, file stuck at ‘Submitted’ state. Reason: Post copy, Environment’s ‘Administration mode’ gets enabled by default, which prevents all background (Async) operations. Fix: Open Power Platform admin center Open the…
-
Continue reading →: Azure function and Cosmos DB Table API – Method not found exception
While creating ‘Entities’ in Azure cosmos Table API from Azure function we encountered following exception. Reason: Azure Function application project was configured using ‘Azure Function v1 (.NET Framework)’. “Microsoft.Azure.Cosmos.Table” nuget package is not compatible with ‘Azure Function v1 (.NET Framework)’. Fix: Change the Azure Function application project type to .NET…


