Power Platform/Dynamics CRM: January 2022

Saturday, January 29, 2022

Create HTML Table with Border while sending Email using Microsoft Flow

Introduction:

In this Blog, we will see how to send email with Border while Sending email using Microsoft Flow

Implementation Steps:

Usually when we send an email with HTML Table Body Microsoft Flow cannot generate Table Border. Below is the Sample Screenshot how the Table will be

Microsoft Flow HTML Table With out Border :

Microsoft Flow HTML Table with Border:

How Can we Achieve this?

Open/Create Microsoft Flow --> Open Your Email Notification weather it is Outlook or Send Email Notification

First Create Data Operation and Create a HTML Table

Click Code View

In the Email Body

Create a <table>Pass your Output Value here</table>

HTML Code:

<head>
<style>
table {
  font-family: arial, sans-serif;
  border-collapse: collapse;
  width: 100%;
}

td, th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 8px;
}

tr:nth-child(even) {
  background-color: #dddddd;
}
</style>
</head>

That's it

Thursday, January 27, 2022

Increase / Maximum file size limit for Attachments in Dynamics 365

Introduction:

In this Blog we will see how to set the Maximum size for the attachments and how to increase size for the attachments.

Implementation Steps:

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

2. Click Gear Icon at the Top --> Select Advance Settings

3. It will open Settings Page --> Select Administration

4. Click System Settings

5. Once Page Loaded Select EMAIL Tab

Select Maximum file size (in kilobytes) and Increase the Size the Of the Attachment.

Now Lets see what is the Maximum Size the System will Allow

Based on Dataverse Environment it will only allow Values between 0 through 131,072.

Now Let's See how to Block Unwanted Field Extension Attachments.

Click General tab --> Look for Set blocked file extensions for attachments

That's it

Friday, January 21, 2022

Get Year Difference between 2 Days using Microsoft Flow

Introduction:

In this blog we will see how to count between 2 dates using Microsoft flow

Implementation Steps:

Consider I want to count how many years of experience an Employee have (for Eg) 3 Year experience

So here in my scenario I want to Calculate Today's Year - Employee Joining Year

As Starting get the Current Year in a Variable

utcNow()

The Next step get the Current Year from the Current Date- for that use Substring

substring(variables('Get Current Date'),0,4)

The same way based on your Dataverse or SharePoint List get the Joining Date of Employee

As per Above Image, get the State Date and store it in Variable then As said before use subString to get the Year of Joining Date

substring(variables('Get Anniversery Date'),0,4)

Now Convert the Variable to int and use sub to get the Count between 2 dates

sub(int(variables('Get Current Year')),int(variables('Get Anniversery Year')))

That's it

Friday, January 7, 2022

Error Handling in Canvas PowerApps with DataVerse Environment using IfError

Introduction:

In this Blog we will see how to Handle error in Canvas PowerApps with DataVerse Environment using IfError

Implementation Steps:

Consider a Scenario, we are having 2 tables one is with Account and another with Opportunity

How to Implement Restrict in Dataverse Environment. : https://microsoftcrmtechie.blogspot.com/2022/01/restrict-record-deletion-if-child.html

While Deleting Account if any Opportunity Contains Data then we need to Restrict in PowerApps.

This Restriction will work Perfectly in Dataverse

In PowerApps Canvas if you tried to delete the system won't throw Error, lets see how to handle that

Open Canvas App then Click File then settings

Click Upcoming Features and Toggle On --> Formula-level Error Management

Now Write below code in Delete Button

IfError(Remove([@Accounts], BrowseGallery1.Selected),Notify("Record Contains Child Record"),Notify("Deletion Success"))

Thats it This will throw error if any error occurs

Restrict record deletion if child Record Available in Dataverse or MSCRM Environment

Introduction

In this blog we will see how to Restrict user to delete Record if child record available

Implementation Steps:

Consider we are having 2 Entities

Account --> Parent
Opportunity --> Child

Opportunity Table Contains Lookup to account Entity.

Now do the below steps to Restrict Account Deletion if any Opportunity Available

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

2. Click Dataverse

3. Select Tables

4. Open Account(in my scenario Account is Parent)

5. Click Relationship --> Open Account to Opportunity Relationship --> Click Delete Drop Down --> Select RESTRICT

If you tried to delete Record you will get below error

If you tried to delete the Record you will get below error

That's it

Wednesday, January 5, 2022

Retrieve Quick View Value using JavaScript in Dataverse Environment

Implementation Steps:

What is Mean by Quick View?

If we want to Populate data from One Entity to Another Entity based on Lookup then we can easily create Quick View Form to display the same.

Navigate to Forms --> Open main form --> Select Quick View Component and select respective entity and its Quick Form

Javascript

Quick View Form Name : QuickViewContact

function getQuickViewForm(executionContext)
{
// get form Context
   var formContext = executionContext.getFormContext();
// get Quick View Contact
   var quickViewControl = formContext.ui.quickForms.get("quickviewcontact");
// get First name
   var firstNameControl = quickViewControl.getControl("firstname");
// Show Alert Dialog from FirstName
   Xrm.Utility.alertDialog(firstNameControl.getAttribute().getValue());
}