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 

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  

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

 

 

 

Timer Control in PowerApps

 Introduction: 

In this Blog we will see how to Create and Use PowerApps Timer Control in Dataverse Environment.

 Implementation Steps:

 

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

 

2. Create a new Solution

 

3. Add an Existing Entity or Add New Entity 

 

4. Create New Field

         --> Timer End date (Date and Time)

         --> Timer Start date ( Date and Time)

         --> Status Field with (In-Progress, Pending, Completed) (Choice)

 

 

5. Add the Created Fields in the Form

 

 

6. Now Navigate below Steps

• Navigate to https://make.powerapps.com
• Click Gear Icon at the Top  --> Select Advance Settings
• Select Cuztomization --> Click Customize the system
• Expand Entities --> Expand the Table where you have created the fields
• Click Forms --> Open Main Form
• Click Insert at the Top then Select TIMER

 

 

7. Enter the Name and Label

 

• Failure Time Field --> When Timer Should be Failed
• Success Condition --> When Timer Need to be Success
• Failure Condition --> When Timer Need to be Failed
• Warning Condition --> When Timer Need to be Warning
• Cancel Condition --> When Timer Need to be Cancelled
• Pause Condition --> When Timer Need to be Paused

Based on the Attached Imaged I have used my END Date and TIMER STATUS

 

if Status = Pending  (TIMER SHOULD BE : Paused)

 

 

if Status = In-Progress (TIMER SHOULD BE : Warning)

 

 

 

 if Status = Completed (TIMER SHOULD BE : Success)

 

 

 

That's it 

 

Please find my video for Step by Step Process

 

Retrieve Quick View Value using JavaScript in Dataverse Environment

Introduction:

In this Blog we will see how to get Values from Quick View Form

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

 

 

That's it 

How to get Error Message from Try Block using Microsoft Flow

Introduction 

In this blog we will see how to get the Error Message from TRY in Catch block using Microsoft Flow

Implementation Steps:

1. Navigate to https://flow.microsoft.com

2. Create a new Flow

3. If we follow existing Blog then we can use Try Catch block easily but we cannot get the error message from TRY block to Catch Block

Lets see how to Achieve that

in the Catch block just write result('TRYBLOCKNAME')

In my case it is result('Try')

Thats it :)

Now when an error Message occurs in Try block it will automatically catch the Error Message in Catch Block.