How to Send Email on Behalf of Another User - MSCRM / Power Platform

 Introduction:

In this blog, we will see how to send email on Behalf of Another User in Microsoft Dynamics CRM / Power Platform?

Error i faced in Power Automate Flow:

This issue occurs when i tried to send email on behalf of another User

How to Fix?

1. Navigate to https://make.powerapps.com  or your CRM or your PowerApps Environment.

2. Click Gear Icon at the Top and select Advance Settings

3. Search for Security and Select Security

4. Once the page Look for Security Roles  and search for your Security role to provide Permissions

5. In my case it is Approval User

6. Look for Approval User then Click Miscellaneous privileges then Click Show all privileges and search for EMAIL

7. Now you will Find Send Email as Another User like below

8. Change None to Organization

9. Now Click Save 

That's it.

Conclusion:

By providing this access, User who is having this security role can send email on behalf of another user.

How to Use SUM, COUNT, AVERAGE, MAX, MIN in Canvas PowerApps

Introduction:

In this Blog we will see how to Use SUM, COUNT, AVERAGE, MAX, MIN in Canvas PowerApps.

Steps:

1. Navigate to https://make.powerapps.com

2. Click Apps

3. Select New and Select Apps

4. Click New App and select Start with Page Design

5. Select Blank Canvas template and Tablet

6.  Create a collection like below and paste it in OnStart of the APP

ClearCollect(expenses,
{Item: "Travel", Value: 100},
{Item: "Food", Value: 300 },
{Item: "Hotel", Value: 895 },
{Item: "Hotel",Value: 1300},
{Item: "Accessories", Value: 50},
{Item: "Flight", Value: 800}
);

7. Now Add a label and you can configure expressions like blow

"Count Rows :  "& CountRows(expenses)

"Average :  "& Average(expenses,Value)

"Max :  "& Max(expenses,Value)

"Min :  "& Min(expenses,Value)

"Count Rows :  "& Sum(expenses,Value)

Conclusion:

This is how we can easily configure the Expressions in PowerApps 

Use @mention to collaborate with your team using Notes in Model-driven app/MSCRM

 Introduction:

In this blog, we will see how to Use @mention to collaborate with your team using Notes in Model-driven app/ Microsoft Dynamics CRM.

Steps:

1. Navigate to https://admin.powerplatform.microsoft.com

2. Click Environments at the left side

3. Choose your Respective Environment to enable @mention in my Case am choosing Trial Environment

4. Open the Environment and Click Settings at the Top of the Banner

5. On the Settings Opened, Look for Products ,  Select Collaboration

6. Look for @mention like below screenshot and Enable it and make sure you will enable In-app notifications too

7. Now Click Save

8. Navigate to your CRM System

9. Open any Accounts or the Table where we have Rich Text editor Available

10. Click on Notes and in the Rich Text editor you will see the Users available in the system will get populated.

Conclusion:

Following above steps we can enable mention in MSCMR or Model Driven apps.

"Invalid operation performed" on Merging Account/Contact Record in MSCRM/Dataverse

Introduction:

        In this blog, we will explore how to resolve the Account/Contact merge issue in Microsoft Dynamics CRM / Dataverse. We will identify the possible causes behind the error "Invalid operation performed", analyze the troubleshooting steps, and provide solutions to successfully merge records without issues.

Steps to Resolve the Account/Contact Merge Issue in CRM/Dataverse:

1. Navigate to your CRM/Dataverse environment.

2. In this case, selecting Account to merge records.

3. Open the Model-Driven App where the account records are located.

4. Select two records to be merged.

5. 

   
   
   

6. Click Merge on the Home Page.

7. During the merging process, the issue occurs.

8. 
   
   
   

9. Upon checking the error in the Console, the following error is displayed.

10. 
    
    
    

Solution to Fix the Issue:

Follow the steps below to resolve the error:

1. Go to https://admin.powerplatform.microsoft.com

2. Select Environments.

3. 
   
   
   

4. Open the environment where the error is occurring.

5. Click Settings.

6. 
   
   
   

7. Search for Privacy + Security.

8. Under Allowed MIME Types, enter application/json.

9. 
   
   
   

10. Click Save to apply the changes.

Conclusion:

By following the steps outlined above, you can successfully resolve the "Invalid operation performed" error when merging Account/Contact records in Microsoft Dynamics CRM / Dataverse. Ensuring that the correct MIME type (application/json) is allowed in Privacy + Security settings can help prevent this issue from occurring. Proper configuration and understanding of system settings are key to seamless data management within the platform.

 

Day 23: Creating New Records Programmatically with JavaScript in Dataverse / MSCRM

In this Blog, we will see how to Create New Records Programmatically with JavaScript in Dataverse / MSCRM

var record = {};
record.bosch_dayname = "Name of the Record"; // Text

Xrm.WebApi.createRecord("bosch_day", record).then(
	function success(result) {
		var newId = result.id;
		console.log(newId);
	},
	function(error) {
		console.log(error.message);
	} );

You can pass different parameter based in the "record" to create with field values

How to Retrieve Records using FETCHXML using JavaScript in MSCRM or Dataverse

In this blog we will see how to How to Retrieve Records using FETCHXML using JavaScript in MSCRM or Dataverse

1. Prepare FetchXML ( Login to CRM or Dataverse then Go to Advance Find and Frame your Query and Download the FetchXML)

2. Consider am retrieving All Accounts

function retriveRecordusingFetchXML() {
    var fetchXml = `
<fetch>
  <entity name="account">
    <attribute name="accountid" />
    <attribute name="name" />
  </entity>
</fetch>`;

    var encodedFetchXML = encodeURIComponent(fetchXml);
    var fetchXmlRequest = "?fetchXml=" + encodedFetchXML;
    Xrm.WebApi.retrieveMultipleRecords("account", fetchXmlRequest).then(
        function success(result) {
            for (const record of result.entities) {
                var name = record.name;
            }
        },
        function (error) {
            var alertMessage = { text: error.message };
            Xrm.Navigation.openAlertDialog(alertMessage, null);
        }
    );
}

Use the Above Code to retrieve Record 

you can change the FetchXML based on your requirement.

Day 22: Fetching Records with Xrm.WebApi.retrieveRecord in Dataverse / MSCRM

 In this Blog we will see how to Use Xrm.WebApi.retrieveRecord in Dataverse / MSCRM

Video for your Reference: https://youtu.be/9QHxNtClV-4?si=1vM2lViCY9XngIXW

function retreiveRecord(executionContext) {
    var formContext = executionContext.getFormContext();
    var getCurrentRecordid = formContext.data.entity.getId();
    getCurrentRecordid = getCurrentRecordid.replace("{", "").replace("}", "");
    Xrm.WebApi.retrieveRecord("TABLENAME", getCurrentRecordid , "?$select=fieldname1,fieldname2").then(
        function success(result) {
            console.log(result);
            // Columns
            var bosch_dayid = result["fieldname1"]; 
            var bosch_dayname = result["fieldname2"]; 
        },
        function (error) {
            console.log(error.message);
        }
    );
}