Showing posts with label Canvas. Show all posts
Showing posts with label Canvas. Show all posts

Friday, June 13, 2025

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:


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 

Wednesday, June 11, 2025

Use @mention to collaborate with your team using Notes in Model-driven app/MSCRM

 Introduction:


In this blog, we will see how to Use @mention to collaborate with your team using Notes in Model-driven app/ Microsoft Dynamics CRM.


2. Click Environments at the left side




3. Choose your Respective Environment to enable @mention in my Case am choosing Trial Environment



4. Open the Environment and Click Settings at the Top of the Banner





5. On the Settings Opened, Look for Products ,  Select Collaboration



6. Look for @mention like below screenshot and Enable it and make sure you will enable In-app notifications too



7. Now Click Save

8. Navigate to your CRM System

9. Open any Accounts or the Table where we have Rich Text editor Available

10. Click on Notes and in the Rich Text editor you will see the Users available in the system will get populated.

Conclusion:

Following above steps we can enable mention in MSCMR or Model Driven apps.

Monday, September 30, 2024

Wednesday, September 18, 2024

Day 4 - Validating Form Fields using JavaScript

Introduction:


In this blog we will see how to Validating Form Fields using JavaScript


function validateDateField(executionContext) {
    var formContext = executionContext.getFormContext();

    if (formContext.getAttribute("bosch_destinationdate").getValue() != null &&
        formContext.getAttribute("bosch_sourcedate").getValue() != null) {

        if (formContext.getAttribute("bosch_destinationdate").getValue() < formContext.getAttribute("bosch_sourcedate").getValue()) {
            var alertStrings = { confirmButtonLabel: "Yes", text: "Destination Date Should be Greater", title: "Date Alert" };
            var alertOptions = { height: 120, width: 260 };
            Xrm.Navigation.openAlertDialog(alertStrings, alertOptions).then(
                function (success) {
                    console.log("Alert dialog closed");
                },
                function (error) {
                    console.log(error.message);
                }
            );
        }
    }
}



Thursday, May 23, 2024

Is your Asynchronous plugin or Workflow not running in Dataverse?

Introduction:


In this blog we will see how to enable Asynchronous Operation in MSCRM or Dataverse Environments.


Implementation Steps:

 

1. Navigate to https://admin.powerplatform.microsoft.com/

 

2. Click on Environments

 

rampprakash_0-1716464005067.png

 

 

3. Open the Environment where you want to run your plugins or workflows

 

4. Click Edit 

 

rampprakash_1-1716464055515.png

 

5. It will prompt a PopUp --> Scroll to the Last

rampprakash_2-1716464166239.png

 

 

6. Enable Administration Model and Enable Background Operations

 

That's it :slightly_smiling_face:

Wednesday, April 10, 2024

How to Import Data from Excel to Multiple tables in PowerApps

Introduction:

 

I have created a view on how to import data from excel to multiple tables in Canvas PowerApps

 

Implemented Steps:

 

1. Created 2 tables

 

2. Created Look Up (Related between 2 tables)

 

3. Export Excel from Advance Find


4. Update the Sheet and Update the Another Sheet based on the Look which you created from Point 2.




 


Tuesday, November 28, 2023

How to Enable Copilot for end users in canvas apps

Introduction:


In this Blog we will see how to Enable COPILOT in Canvas PowerApps


Implementation Steps:

 

1. Navigate to https://admin.powerplatform.microsoft.com

 

2. Select the Respective Environment where you want to Enable COPILOT

 

3. Open the Environment

 

rampprakash_1-1701149600928.png

 

4. Click Settings on TOP --> Select Product --> Select Feature

 

rampprakash_2-1701149648231.png

 

 

5. You will see an Option Called COPILOT Enable the Option

 

rampprakash_3-1701149671598.png

 

6. Click Save

 

7. Now go to https://make.powerapps.com

 

8. Click Apps at the Left Side

 

9. Select New and Select Blank Canvas APP

 

10. Once the App Opened --> Click Settings from the top and Click Upcoming Features and Turn On COPILOT COMPONENTS

 

 

rampprakash_4-1701149795634.png

 

11. Once Done Click INSERT and You will See the COPILOT OPTION ENABLED

 

rampprakash_5-1701149856263.png

 

 

 

Note:

 

Current its based on the REGION Specific

Thursday, August 31, 2023

How to Use Delete Operations in Microsoft Dataverse or MSCRM

Introduction:


In this Blog we will see how to use Delete operations in Microsoft Dataverse or MSCRM


Implementation Steps:

 

As I mentioned in my Previous Blog you can able to follow how to use Dataverse Connection with Console Application.

 

In this Blog we will see how to use Delete Operation in Dataverse

 

Copy and Paste the below Code for Delete Operations

 

CrmServiceClient service = new CrmServiceClient(connectionString);
service.Delete("account", new Guid("a4cea450-cb0c-ea11-a813-000d3a1b1223"));

 

"account" --> Entity Logical Name

"a4cea450-cb0c-ea11-a813-000d3a1b1223" --> GUID of the Record to Delete

Friday, August 11, 2023

How to Use Update Operations in Microsoft Dataverse or MSCRM

Introduction:


In this Blog, we will see how to use Update Operations in Microsoft Dataverse or MSCRM.


Implementation Steps:

 

As I mentioned in my Previous Blog you can able to follow how to use Dataverse Connection with Console Application.

 

In this Blog we will see how to use Update Operation in Dataverse

 

Copy and Paste the below Code for Update Operations

 

Entity updateAccount = new Entity("account");
updateAccount.Id = new Guid("e0385c7b-8b32-ee11-bdf4-002248d5d764");
updateAccount["name"]= "Updated from Console Application";
service.Update(updateAccount);

 

"account" --> Entity Logical Name

"e0385c7b-8b32-ee11-bdf4-002248d5d764" --> GUID of the Record to Update

"name" --> Field Name to Update

"Updated from Console Application" --> Values to be Updated

Wednesday, May 31, 2023

Host in Canvas PowerApps

Introduction: 


In this Blog we will see how to use Host in Canvas PowerApps


Implementation Steps:

 

In Canvas PowerApps there is an Option Called Host which Contains

  • BrowserUserAgent
  • OSType
  • SessionID
  • TenantID

1. BrowserUserAgent : This Will Show the User's Browser Agent

 

rampprakash_0-1685529895877.png

 

 

2. OSType : Type of OS 

 

rampprakash_1-1685529933795.png

 

3. Session ID: Current Session ID

 

rampprakash_2-1685529960681.png

 

 

4. Tenant ID: Tenant id (Environment ID)

             

rampprakash_3-1685530007019.png

 

 

That's it :slightly_smiling_face:

Wednesday, April 26, 2023

How to Share Canvas PowerApps in Power Platform ?

Introduction:


In this Blog, we will see how to share Canvas PowerApps in Power Platform.


Implementation Steps:

 

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

 

2. Click Apps at the Left Side

 

3. Select the Apps which you want to Share 

 

rampprakash_0-1682505817438.png

 

4. Now Click On Share

 

5. Input the Name

 

rampprakash_1-1682505873632.png

 

6. Once User Added then Select weather the User Can be Co-Owner or not

 

7. If Co-Owner Select the Check Box at the Right Side Form

 

8. Now Click Share :slightly_smiling_face:

 

 

That's it :slightly_smiling_face:

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 va...