Power Platform/Dynamics CRM: PowerApps

Showing posts with label PowerApps. Show all posts

Wednesday, October 15, 2025

How to Add Static Text to CRM or Dataverse Using HTML Web Resources

Introduction:

In this Blog, we will see how to Add Static Text to CRM or Dataverse Using HTML Web Resources

Implementation Steps :

Navigate to https://make.powerapps.com
Click Solutions
Open the Solution or Create a New Solution
Click New --> Select Web Resource
Select Type as HTML

Input below Code

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>Static Text</title>
    <style>
        body {
            font-family: "Segoe UI", Tahoma, Geneva, Verdana, sans-serif;
            font-size: 14px;
            color: #333;
            margin: 0;
            padding: 0;
            background-color: transparent;
        }

        .static-text {
            padding: 0;
            border: none;
            background: none;
        }
    </style>
</head>
<body>
    <div class="static-text">
        This is a static text.
    </div>
</body>
</html>

Click Save and Publish
Open the form where you want to display this HTML
Like Account --> Information Form
Once Form Opened Drag and Drop HTML
Click Add
Now Save and Publish the Form

Conclusion:

This is one of the easiest way to add static text in MSCRM or Dataverse

Friday, June 13, 2025

How to Send Email on Behalf of Another User - MSCRM / Power Platform

Introduction:

In this blog, we will see how to send email on Behalf of Another User in Microsoft Dynamics CRM / Power Platform?

Error i faced in Power Automate Flow:

This issue occurs when i tried to send email on behalf of another User

How to Fix?

1. Navigate to https://make.powerapps.com or your CRM or your PowerApps Environment.

2. Click Gear Icon at the Top and select Advance Settings

3. Search for Security and Select Security

4. Once the page Look for Security Roles and search for your Security role to provide Permissions

5. In my case it is Approval User

6. Look for Approval User then Click Miscellaneous privileges then Click Show all privileges and search for EMAIL

7. Now you will Find Send Email as Another User like below

8. Change None to Organization

9. Now Click Save

That's it.

Conclusion:

By providing this access, User who is having this security role can send email on behalf of another user.

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:

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

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

Friday, May 3, 2024

How to Run Microsoft Flow for Every one Month

Introduction:

In this Blog we will see how to Run Microsoft Flow for Every one Month.

Implementation Steps:

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

2. Click My Flows at the Left Side

3. Click New Flows and Select Scheduled Cloud Flows

4. Once Selected it will prompt a page there enter the Name of the Flow and Select the Date on when to trigger and Select the Repeat every 1 MONTH

That's it

Tuesday, March 19, 2024

How to Use Multilingual Language in Canvas PowerApps

Introduction:

In this Blog, we will see how to use multilingual language in Canvas PowerApps

Implementation Steps:

1. Open an Excel and Create Data Like Below and Save the Excel.

2. Now Navigate to https://make.powerapps.com

3. Click Apps

4. Click New Apps --> Page Design

5. Click Data Source at the Left Side and Search for IMPORT FROM EXCEL

6. Now Select the Excel from your Saved Location

7. Once After Selected the Excel you will see the Data Gets added Successfully in the PowerApps

8. Now in On Start of App write Below Code to get the Lanaguage of User (based on Broswer)

Set(
getCurrentLanguageofLoggedinUserBrowser,
Coalesce(
Lower(
Left(
Language(),
2
)
),
"en"
)
)

9. Now Add 3 labels (Click Insert and Click Labels)
Write Below Code
LookUp(Table2,LanguageTag=getCurrentLanguageofLoggedinUserBrowser && TextID = "Approved Leave").Text
LookUp(Table2,LanguageTag=getCurrentLanguageofLoggedinUserBrowser && TextID = "Pending Leave").Text
LookUp(Table2,LanguageTag=getCurrentLanguageofLoggedinUserBrowser && TextID = "Rejected Leave").Text

10. That' it . Now will run the PowerApps

11. For English