How to find Difference between two dates in Days with calculated fields in Model Driven Apps

Introduction:

In this Blog, we will see how to find difference between two date in Days using Calculated fields in Model Driven Apps.

Implementation Steps:

 

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

 

2. Click Solutions (if Already Available) else create a new Solution and add New Table or Existing Table

 

3. Create a new Field inside that Table (Start Date)

 

 

4. Create another field called End Date 

 

 

5. Save the Table

 

6. Create a Whole Number Field as Calculated

 

 

7. Click Calculation --> It will save the table and open a Separate Tab.

 

8. Once the Page Opens add following Condition

•    Start Date Contains Data
•    End Date Contains Data

9. Add DiffInDays (It is used to find difference between two dates)

 

10. Write below Query in the Action Field

 

DiffInDays(cr2f9_startdate, cr2f9_enddate)

 

 

11. Now add 

• Start Date
• End Date
• Difference in Date 

Fields into the Form.

 

12. Open a new Record and Input Date and Click Save

 

Positive Number : (End Date is Future)

 

 

 

Negative Number : (End Date is Past)

 

 

 

That's it 

Hide Command Bar using JavaScript in Model Driven App

Introduction:

In this Blog, we will see how to hide Navigation Bar in Model Driven App using JavaScript.

Implementation Steps:

 

When ever you tried to create a new Record, you will be redirected to a page like below

 

 

Red Color Highlighted Called Command Bar

 

If we want to hide that Command Bar follow below steps to achieve the same.

 

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

2. Click Solutions --> Create a new Solution

3. Click New --> Click More --> Select Web Resource and add a new Web Resource

 

4. Write below code in Web Resource

 

 

function onLoadHideCommandBar(executionContext) {
    var formContext = executionContext.getFormContext();
    formContext.ui.headerSection.setCommandBarVisible(booleanValue);
}

 

 

booleanValue : pass true or false as an option

 

true - visible Command bar

false - hide Command bar

 

Once Code Published:

 

Load or Open a new Record

 

 

Now you cannot see the Navigation Bar.

 

That's it 

 

How to validate weather the number is Positive or Negative in Canvas Application

Introduction: 

In this blog we will see how to check weather number is POSTIVE or NEGATIVE in CANVAS APP

Implementation Steps:

 

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

 

2. Click Apps --> Click New --> Select Canvas App --> Choose Tablet/Phone based on your needs --> Enter name and Click Ok

 

3. Add Label and Name it as INPUT NUMBER

 

4. Add Text Box and Change format to NUMBER (Name it as txtnumber)

 

5. Add Submit Button

 

 

6. On Select of Submit Button Write Below Code

 

If(Value(txtnumber.Text)>0,Notify("Enter Number " & txtnumber.Text & " is Positive",NotificationType.Success),Notify("Enter Number " & txtnumber.Text & " is Negative",NotificationType.Success))

 

Testing:

 

Input Number : 5 and Submit

 

 

Input Number : -5 and Submit

 

 

 

That's it 

 

How to Customize Tool Tip for a Field in Model Driven Apps

Introduction:

In this Blog we will see how to Add or Customize Tool Tip for a Field in Model Driven Apps or CRM

Implementation Steps:

 

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

2. Click Data

3. Click Tables

4. In this Scenario am taking Account table as an Example

     --> Create a New Field

 

I Created a Field Called Tool Tip

 

5. Once the Field Gets Created --> Add that Field in the Form.

 

6. Once Field Gets Added --> if you open a record you will see Default Tool tip will populate the Display Name.

 

 

     

Let's see how we can customize this.

 

7. Open the Created Field --> Fill the Description Field

 

 

8. Save and Publish it Again

 

9. Now Open a Record --> Move Hover to the Field

 

 

That's it 

 

Form Notification in Model Driven Apps Using JavaScript

Introduction:

In this blog we will see how to show Form Notification using JavaScript in Model Driven Apps.

Scenario:

Consider i have an Account Screen, with Annual Revenue field as 5000, if the value exceed more than 5000 i need to show an Notification.

 

 

Implementation Steps:

 

1. Create a WebResource 

2. Open the JavaScript (Web Resource which you have Created).

 

Creating WebResource:

 

 

Adding Web Resource to Form

 

 

In My Scenario, am triggering alert on Change of Field Value.

 

 So, Open the Form --> Click on the Field --> Click Events --> Then Input the Event name (Function name) and WebResource where the Function residing --> Save --> Publish

 

 

 

Write the below Code in the JavaScript

 

function onChange(executionContext){
var formContext = executionContext.getFormContext();
if(formContext.getAtrribute("annualrevenue").getValue()>5000){
formContext.ui.setFormNotification("Annual Revenue should be less than 5000", "INFO", "1");
}
else{
formContext.ui.clearFormNotification("1")
}
}

 

Notification Pop-up:

 

 

No Notification(Because we are Clearing the Notification):

 

 

 

Once written above code, just save and publish.

 

That's it 

Create Notes / Move Notes and Attachments from One Entity to another

Introduction:

In this blog we will see how to move Notes from One Entity to Another

Implementation Steps:

 

Consider when ever I Qualify a Lead to Contact, I need to Move the Respective Lead(Notes/Attachment) from Lead to Contact.

 

Let's see how can we do that.

 

Create a Plugin 

 

string getNotes = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
  <entity name='annotation'>
    <all-attributes />
    <order attribute='subject' descending='false' />
    <link-entity name='lead' from='leadid' to='objectid' link-type='inner' alias='aa'>
      <filter type='and'>
        <condition attribute='leadid' operator='eq' value='{objectid}' />
      </filter>
    </link-entity>
  </entity>
</fetch>";

                getNotes = getNotes.Replace("{objectid}", "LEADGUID");
                EntityCollection collectNotes = service.RetrieveMultiple(new FetchExpression(getNotes));

                foreach (var loopColelctNotes in collectNotes.Entities)
                {
                    Entity _annotation = new Entity("annotation");
                    _annotation.Attributes["objectid"] = new EntityReference("contact", getContactDetails.Id);
                    _annotation.Attributes["objecttypecode"] = "contact";
                    if (loopColelctNotes.Attributes.Contains("subject"))
                    {
                        _annotation.Attributes["subject"] = loopColelctNotes.Attributes["subject"];
                    }

                    if (loopColelctNotes.Attributes.Contains("documentbody"))
                    {
                        _annotation.Attributes["documentbody"] = loopColelctNotes.Attributes["documentbody"];
                    }

                    if (loopColelctNotes.Attributes.Contains("mimetype"))
                    {
                        _annotation.Attributes["mimetype"] = loopColelctNotes.Attributes["mimetype"];
                    }

                    if (loopColelctNotes.Attributes.Contains("notetext"))
                    {
                        _annotation.Attributes["notetext"] = loopColelctNotes.Attributes["notetext"];
                    }

                    if (loopColelctNotes.Attributes.Contains("filename"))
                    {
                        _annotation.Attributes["filename"] = loopColelctNotes.Attributes["filename"];
                    }

                    service.Create(_annotation);

                }

 

Trigger the above code on Create of an Entity in Async Operation.

How to Show Hyper link in Canvas PowerApps

Introduction:

In this Blog we will see how to show HyperLink in PowerApps Canvas.

Implementation Steps:

 

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

 

2. Click Apps --> Select new --> Select Canvas App (Tablet/Phone)

 

3. Once Page Loaded --> Click Insert --> Click Text --> Select HTML Text

 

 

 

4. Once HTML Loaded  --> Click HTML TEXT in fx and write below code

 

"<a href='https://microsoftcrmtechie.blogspot.com'>Open Ram Blog</a>"

 

 

 

5. Now Run the Application 

 

 

That's it  if you click on the Link it will open up in Another Page