Power Platform/Dynamics CRM

Tuesday, April 5, 2022

Create a Web Resource in Model Driven Apps

Introduction:

In this Blog we will see how to Create Web Resource in Model Driven Apps.

Implementation Steps:

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

2. Click Solutions

3. Create a new Solution

4. Click Create to Create a Solution

5. Once Solution gets Created --> Open Your Visual studio to Create a JavaScript file ( Web Resource is not restricted to JS alone), please find the Screenshot below for the list of items we can create in Web Resource

6. I have taken VS to Create a new JS file

7. I have Written Some Sample JS Code

function sampleJavaScript() {
    alert("hello");
}

8. Once JS is Ready open the Created Solution --> Click New --> Click More --> Click Web Resource

9. Input the Display Name/Name/Type

10. In My Case Type as JavaScript --> Then Click on Browse --> Select the JavaScript which we have created

11. Click on Save.

That's it

Then we can add this JavaScript in Any Place of Forms Etc.,.

Monday, April 4, 2022

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

Introduction:

In this Blog we will see how to find Difference between two dates in Hours with 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 DiffInHours (It is used to find difference between two dates)

10. Write below Query in the Action Field

DIFFINHOURS(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

How to Enable or Disable AUTO SAVE in Model Driven Apps/MSCRM/Dataverse

Introduction:

In this Blog we will see how to Enable/Disable Auto Save functionality in MSCRM or Model Driven Apps

Implementation Steps:

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

2. Click Apps --> Open your Model Driven Apps

3. If the Model Driven Apps is not Available then Once Navigated to Point 1 --> Click Gear Icon at the Top --> Click Advance Settings

4. Once Advanced Settings Page Loaded --> Click Settings --> Click Administration

5. Then Select System Settings

6. It Will Open a Popup

7. In the General Tab You will see an option called ENABLE AUTO SAVE ON ALL FORMS

Select Yes or No based on Our Needs.

Yes --> It will Automatically Saves once you changed the value

No --> You need to Forcefully Click on Save Button to Save the Record.

That's it

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

Friday, April 1, 2022

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

Friday, March 25, 2022

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