Posts

Custom Subgrid Using HTML Web resource

By
Sometimes you will get requirement to show records in subgrid without any proper relationship. In such scenario you can go with custom subgrid and show all those related records in HTML table that won't be possible with OOB way of ms crm Below is the sample code for HTML web resource for creating sample custom subgrid Here we are showing all accounts in Case entity where matching criteria is Case Number = Account number(that too without any relationship between Case and account) html><head><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta...
Post a Comment
Read more

Power Apps Portals - Lock/Unlock User Account for Invalid Sign In Attempt

By
  Site Settings that are related to Invalid Sign In Attempt. you can configure these site settings as per your requirement. Authentication/LoginThrottling/IpAddressTimeoutTimeSpan : The amount of time the IP address will have to wait if Authentication/LoginThrottling/MaxInvaildAttemptsFromIPAddress occur within Authentication/LoginThrottling/MaxAttemptsTimeLimitTimeSpan amount of time. Default: 00:10:00 (10 mins) Authentication/LoginThrottling/MaxAttemptsTimeLimitTimeSpan The amount of time the Authentication/LoginThrottling/MaxInvalidAttemptsFromIPAddress are to be within before the IP address has to wait Authentication/LoginThrottling/IpAddressTimeoutTimeSpan. Default: 00:03:00 (3 mins) Authentication/LoginThrottling/MaxInvaildAttemptsFromIPAddress The default number of unauthenticated login attempts from an IP address before the IP address is blocked for Authentication/LoginThrottling/IpAddressTimeoutTimeSpan if the attempts occur within Authentication/LoginThrottling/MaxAttempt...
Post a Comment
Read more

Power Apps Portal - Authentication, Authorization

By
Image
 In Power Apps Portal we have below Authentications methods: Registration -  With this option any user can register with portal and access portal. This is open registration To enable and disable this option following property needs to be set true/false in site settings: Authentication/Registration/OpenRegistrationEnabled 2. Redeem Invitation : If User have Invitation code to register on portal then user will use that code and register with portal (For more information follow below video) To enable and disable this option following property needs to be set true/false in site settings: Authentication/Registration/InvitationEnabled 3. External login : This is used when user want to login by using external authentication. eg Azure AD, Facebook, LinkedIn, etc. To enable and disable this option following property needs to be set true/false in site settings: Authentication/Registration/ExternalLoginEnabled Authentication/Registration/AzureADLoginEnabled For more...
Post a Comment
Read more

ADF - (Part3) Integrate Data From CRM to External system Using Stored procedure

By
Image
 In this blog we will see how we can use stored procedure to transform our data in ADF.  For better understanding you can check my previous blog for better understanding. When we integrate CRM data to external system SQL, then for  Option-Set fields present in CRM, we get Option-Set values and not Text value. eg. we have Credit Hold option set field in CRM and after integration we are getting option set value. To solve this problem we will create OptionSetMetaData table in SQL which will store details about option-set fields SQL query to create OptionSetMetaData table CREATE TABLE [dbo].[OptionSetMetadata]( [ID] [uniqueidentifier] NULL, [EntityName] [varchar](50) NULL, [OptionSetFieldName] [varchar](50) NULL, [OptionSetText] [varchar](50) NULL, [OptionSetValue] [int] NULL ) //To Insert Records in sql Table Insert Into OptionSetMetadata Values (NEWID(), 'account', 'Credit Hold', 'Yes', 1) Insert Into OptionSetMetadata Values (NEWID(), 'account...
2 comments
Read more

ADF - (Part 2) Integrate Data From CRM to External system

By
Image
 In this blog we will integrate data from Microsoft Dynamic CRM to External system's SQL databse. we are going to integrate Account and Contact tables from CRM to external system Before starting with this, you should have following things :  1. Microsoft Dynamics CRM Environment 2. Microsoft SQL Server Management Studio Software(SSMS) 3. Azure Portal account First connect to your SQL server in SSMS and create Account and Contact Table. You can use following query to create table CREATE TABLE Account( [AccountId] [uniqueidentifier] NULL, [AccountName] [varchar](200) NULL, [CreditHold] [int] NULL ) CREATE TABLE Contact( [ContactId] [uniqueidentifier] NULL, [name] [varchar](200) NULL, [MobileNumber] [varchar](50) NULL, [FirstName] [varchar](200) NULL, [LastName] [varchar](200) NULL, [AccountID] [uniqueidentifier] NULL, [AccountName] [varchar](200) NULL ) After creating tables, Navigate to Azure Data factory in azure portal, and Create Dataset for your source and de...
Post a Comment
Read more

ADF - (Part 1) Create Resource Group and Azure SQL DB

By
Image
Resource Group in Azure is container which will hold your related Azure service or resources.  eg. If you want to create SQL server in azure portal then you can create SQL server and link that SQL server to particular resource group. You can check out below video for creating Resource group and Azure SQL DB.
Post a Comment
Read more

Perform logic on change of DateTime field

By
 Writing business logic on change of DateTime field in CRM portal using jQuery is different than normal on change function. eg. If we want to check whether entered date is in past or not then we will use following syntax :  In our case Start Date is the field where we are adding validation. Schema name for start date is new_startdate var dpcontrol = $("#new_startdate_datepicker_description").closest("div.control"); $(dpcontrol).on("dp.change", function (e) { var dateVal = $("#new_startdate").val(); if (dateVal != null) { var newDate = new Date(dateVal), now = new Date(); newDate.setHours(0,0,0,0); now.setHours(0,0,0,0); if (newDate
Post a Comment
Read more