Thursday, August 31, 2023

How to Use Delete Operations in Microsoft Dataverse or MSCRM

Introduction:


In this Blog we will see how to use Delete operations in Microsoft Dataverse or MSCRM


Implementation Steps:

 

As I mentioned in my Previous Blog you can able to follow how to use Dataverse Connection with Console Application.

 

In this Blog we will see how to use Delete Operation in Dataverse

 

Copy and Paste the below Code for Delete Operations

 

CrmServiceClient service = new CrmServiceClient(connectionString);
service.Delete("account", new Guid("a4cea450-cb0c-ea11-a813-000d3a1b1223"));

 

"account" --> Entity Logical Name

"a4cea450-cb0c-ea11-a813-000d3a1b1223" --> GUID of the Record to Delete

Friday, August 11, 2023

How to Use Update Operations in Microsoft Dataverse or MSCRM

Introduction:


In this Blog, we will see how to use Update Operations in Microsoft Dataverse or MSCRM.


Implementation Steps:

 

As I mentioned in my Previous Blog you can able to follow how to use Dataverse Connection with Console Application.

 

In this Blog we will see how to use Update Operation in Dataverse

 

Copy and Paste the below Code for Update Operations

 

Entity updateAccount = new Entity("account");
updateAccount.Id = new Guid("e0385c7b-8b32-ee11-bdf4-002248d5d764");
updateAccount["name"]= "Updated from Console Application";
service.Update(updateAccount);

 

"account" --> Entity Logical Name

"e0385c7b-8b32-ee11-bdf4-002248d5d764" --> GUID of the Record to Update

"name" --> Field Name to Update

"Updated from Console Application" --> Values to be Updated

Monday, August 7, 2023

How to Use Create Operations in Microsoft Dataverse or MSCRM

Introduction:


In this Blog we will see how to use Create Operations in Microsoft Dataverse or MSCRM environment.


Implementation Steps:

 

As I mentioned in my Previous Blog you can able to follow how to use Dataverse Connection with Console Application.

 

In this Blog we will see how to use Create Operation in Dataverse

 

Copy and Paste the below Code for Create Operations

 

 

 

static void Main(string[] args)
        {
            // Connection string to Dynamics 365
            string connectionString = "AuthType=Office365;Url=https://URL.crm8.dynamics.com/;Username=username@environment.onmicrosoft.com;RequireNewInstance=true;Password=PASSWORD;";

            // Create the CrmServiceClient instance using the connection string
            CrmServiceClient service = new CrmServiceClient(connectionString);

            // Check if the connection was successful
            if (!service.IsReady)
            {
                Console.WriteLine("Failed to connect to Dynamics 365.");
                return;
            }
            else
            {
                Entity createAccount = new Entity("account");
                createAccount["name"] = "Demo Account";
                createAccount["OPTION SET LOGICAL NAME"] = new OptionSetValue(10000);
                createAccount["ENTITY REFERENCE LOGICAL NAME"] = new EntityReference("Entity LogicalName", new Guie(GUID OF RECORD));
                service.Create(createAccount);
            }
        }

 

"account" --> Table Name

"name" --> Logical Name of field Name

OptionSetValue --> to set Drop Down Values

EntityReference --> LookUp Reference.

 

That's it :slightly_smiling_face:

How to Import Data from Excel to Multiple tables in PowerApps

Introduction:   I have created a view on how to import data from excel to multiple tables in Canvas PowerApps   Implemented Steps: ...