-
Continue reading →: [Step by Step] Connecting to Azure SQL Server using OLEDB Connection from SSIS
Connecting to Azure SQL Server from SSIS using ‘OLEDB Connection manager’ is not a straight forward way, if you are to connect using your ‘Azure Account’ credentials. The only way to connect using ‘Azure Account’ is by using ‘ADO.NET connection’ manager. But then, how to connect to Azure SQL using…
-
Continue reading →: PowerApps – Create an ‘Account’ in Dynamics 365 from App using Flow
If you are new to PowerApps, please go through my previous blog In this post, lets build an App with an Account Form and create the record in Dynamics 365. Prerequisite: You must have a PowerApps account. Refer blog for details. Create a Microsoft Flow with logic to create an Account record in Dynamics…
-
Continue reading →: PowerApps – Error while connecting to Excel Data Source
If you are new to PowerApps, please go through my previous blog In my last Post building, I explained the steps to build an App using Excel file as Data Source. While I was exploring more with that App, I encountered an error when playing with different excel files. Reason & Fix: If…
-
Continue reading →: PowerApps – Build an App using Excel data as Source
If you are new to PowerApps, please go through my previous blog In this post, I am going to walk you through building an App using Excel as ‘Data Source’. I am going to build an App by Prepare an Excel file with data formatted as ‘Table’ Place it in…
-
Continue reading →: PowerApps – Step By Step – Build a simple Calculator App
In my previous article I detailed the steps to get started with PowerApps by signing up to the PowerApps portal. Now, let me walk you through the steps to create and publish a simple ‘Calculator’ App. The Calculator App will have 2 Text boxes and an ‘Operation’ dropdown. Upon clicking the…
-
Continue reading →: PowerApps – Getting started
PowerApp is a service from Microsoft Business Application Platform (BAP) for creating business applications that can run in a browser or on a phone or tablet, and no coding experience is required. Its a 3 step approach to create an App Connect to a Data Source; It can be your Dynamics…
-
Continue reading →: CRM 2011 (on-premise) – Querying Filtered views from CRM DB
We recently working on Data migration from CRM 2011 on-premise to Dynamics 365. We got the CRM 2011 SQL DB back up, which we restored in our SQL server. But when we run query on ‘Filtered’ views we were getting 0 results. Reason: FilteredViews always run on CRM User context…
-
Continue reading →: Dynamics 365 – Different types of User Accounts and License consumption
Other day I was asked a question “What are the options to create/migrate users in Dynamics 365 application with no license consumption” The options are Create a User of type ‘Stub User’ which does not consume license Sync a User from O365 to Dynamics 365 and remove the license later.…
-
Continue reading →: Dynamics 365 – How to get App URL
Using PowerApps, we can create custom business apps comprised of components such as entities, dashboards, forms, views, charts, and business processes. Its convenient way to package and provide the components which are matter to the Users. Lets take a scenario to understand this better A sales company has users having…
-
Continue reading →: D365 – Unified Interface – Create an App and Grant App access to a Security Role
In this article, I am going to provide steps to create new App and how to grant the App access to a particular Security Role. Prerequisite to create App: User must have the following privileges to create App: Create, Read, and Write privileges for the “App” entity Read and Write…


![[Step by Step] Beginner : Create a PCF control and add it to a custom page](https://rajeevpentyala.com/wp-content/uploads/2024/12/image-49.png)