Built a PowerApps control that shows PDF files saved records in MSCRM/Dataverse

Please find my YouTube Video link for Built a PowerApps control that shows PDF files saved records in MSCRM/Dataverse YouTube Link

Git Hub Link : https://github.com/rampprakash/dataverse-pdf-display

Dataverse/MSCRM: Work with Masking Rule

 Introduction:

In this blog, we will see how to work with Masking Rule in MSCRM or Dataverse.

Issue : I don't want to show the Email values in Contact table. For example if i have email as ram@contosso.com i need to only show ram* (here * denotes masking).

Steps to Achieve:

1. Navigate to https://make.poweapps.com
   
   
2. Choose your respective Environment
   
   
3. Go to your solution and open the solution
   
   
4. Now if you click on New you will see 2 Options
   
   
   1. Attribute Masking Rule - You can mask the attribute based on SECURED MASKING RULE
      
      
   2. Secured Masking Rule - RULE TO BE DEFINED
      
      
      
      
5. Now first Click on SECURED MASKING RULE
   
   
6. Once you clicked it will prompt a page
   
   
   1.  You need to define your rule like below
      
      
      
      Name : Input your valid name with _
      Display Name : Input your display Name
      Description : Explain about your Rule
      Regular Expression : You can input your expression, for me i need to hide my domain so i used (?<=@).*$
      Masked Character : How you want to show your Masked Character
      Enter Plain Text : For testing you can input your Name
      Masked Plain Text : You can see your demo Value
      
      
7.  Once done click Save
   
   
8. Now Create an Attribute Masking
   
   
9. Before Creating Attribute Masking you need to make sure your Column Security is Enabled
   
   
   
   
   
10.  You can Use Attribute Masking in 2 Places ( you can directly Select here) or You can click on New and create like below
    
    
    

 Now save this and test it

Conclusion:

Following above steps we can achieve Masking for an Attribute.

Bulk Delete Operation in Dataverse/MSCRM

 Introduction:

In this blog we will see how to Bulk Delete Operation in Dataverse/MSCRM

Steps:

1.  Navigate to https://make.powerapps.com
   
   
2. Click Apps
   
   
3. Open your Model Driven Apps
   
   
4. Now Click on Settings icon at the TOP right Corner of screen
   
   
5. Select Advance Settings
   
   
6. 
   
   
7. Once the Page Gets Loaded Select Data Management and Select Bulk Record deletion
   
   
8. 
   
   
9.  Click New JOB
   
   
10.  Select the Table and If you have any Particular Views select the view (or) Add filter Criteria for the condition and Click Preview Records to Verify the same
    
    
11.  Once Verified Click Save and open the Operation to view the status of the Record
    
    

​​​​​​​
That's it :)

Conclusion:

Based on the above steps you can easily delete the multiple Records using Out-of-the-box behaviour

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);
        }
    );
}