Cancelled Appointments not synced in Outlook ?

 Introduction:

In this blog, we will see how to sync Cancelled Appointments in Outlook.

Implementation Steps:

• 1. Navigate to https://make.powerapps.com
  
  
• 2. Select Correct Environments
  
  
• 3. Select Gear Icon on the top and Click Advance Settings
  
  
• 4. Select Solutions and Import the attached Solution (OrganizationSettingsEditor_Managed.zip)
  
  
• 5. Once the Solution is Imported then Select Publish all customizations
  
  
• 6. Now search with "OrganizationSettingsEditor" and Open the Solution
  
  
• 7. Search for "SSSPropagateAppointmentCancellationsToExchange"
  
  
• 
  
  
• Click On EDIT
  
  
  
  
  
  
  
• Set the textbox to true (small case)
  
  
• Click Update
  
  
1. It will Prompt "Proceed with pushing a change into CRM?" Click OK
   
   

Conclusion:

That's it now Create an appointment and cancel it and it will get synced to Outlook.

How to View Flow Run History in Power Automate?

 Introduction:

In this blog, we will see how to View Flow Run History in Power Automate.

Implementation Steps:

1.  Navigate to https://admin.powerplatform.microsoft.com
   
   
2. Click Manage
   
   
3. Select Environments
   
   
   
4. Open the Environment where you want to change Run History of Power Automate
   
   
5. In my case it is Trail Environment
   
   
   
6.  Open the Environment
   
   
7. Click Settings and select features
   
   
   
8. Look for "Cloud flow run history in Dataverse"
   
   
   
   
9.  Update the History 
   1. Enabled - 28 days retention (default)
   2. Enabled - 14 days retention
   3. Enabled - 7 days retention
   4. Disabled
      
      
10. You can select the option how many days you want to be retained
    
    
11. Update the drop down and Select Save

Conclusion:

Based on above steps we can update the retention for Cloud flow run history in Dataverse.

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