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 

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 

 

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

 

12. For Arabic

 

How to Install Smart Buttons for Ribbon Workbench using XrmToolBox

Introduction:

In this blog we will see how to install Smart Buttons for Ribbon Workbench using XRMToolBox

Implementation Steps:

 

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

 

2. Click Solutions

 

3. Select Import Solutions and import Ribbon Work Bench (Download here)

 

 

4. Once Solution Imported then Click Gear Icon at the Top and Select Advance Settings

 

5. Select Solutions --> You will find Ribbon Work Bench

 

6. Click the Ribbon Work Bench it will open PopUp like below

 

 

7. At the Left side you can see the Smart Button but it does not contain any values

 

Let's see how to show SMART Buttons

 

8. Now Click Below Link

 

https://ribbonworkbench.uservoice.com/knowledgebase/articles/896958

 

9. Once You Opened Link you will find another Link

 

https://github.com/scottdurow/RibbonWorkbench/releases

 

10. Once you clicked on Above Link you will redirect to Github and Download the Highlighted Solution

 

 

11. Now again go to Solutions (Follow Point 1 and 2)

 

12. And Import Solution downloaded from Point 10

 

13. Select the Solution and Click Import

 

 

14. Now again go to Legacy Mode and Click on Solutions and Select Ribbon Work Bench Again

 

15. Once page loaded you can find the Smart Buttons.

 

 

 That's it 

 

How to Filter Gallery with SharePoint with Blank Values Without Delegation Warning

Introduction:

In this Blog we will see how to Filter Gallery with SharePoint with Blank Values Without Delegation Warning.

Implementation Steps:

 

In this Blog am using Back End as SharePoint.

 

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

 

2. Click Apps 

 

3. Select Canvas App and Select Type as Either Phone Mode or Tablet Mode and input Name

 

 

4. Click Create

 

5. Add Data Source (Here in my scenario am selecting Data Source as SharePoint)

 

 

6. Add Gallery and Select Items as SharePoint

 

 

7. Now Select the Items as SharePoint List

 

 

 

8. Now Consider I need to filter the Title as Blank without Delegation Warning

 

9. If i use IsBlank then it will cause Delegation Warning

 

 

 

Delegation Code : Filter('Account List - New',IsBlank(Title))

 

10. Based on Below Code we can avoid Delegation

 

 

 

Non-Delegation Code: Filter('Account List - New',Title = Blank())

 

That's it 

How to get Quarters from Date in Canvas PowerApps

Introduction

In this Blog we will see how to get Quarters from Date in Canvas PowerApps

Implementation Steps:

 

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

 

 

2. Select Apps --> Select New App --> Select Canvas

 

3. Once Page Opened Input the name and Select Tablet or Phone depends on your requirement, from my end am selecting Tablet Mode

 

 

4. Once Page Get Opened  --> Add a Label by Selecting (Insert --> Label) and Add a Button as Well

 

 

5. Now Select the Button and go to OnSelect and Write below code Logic

 

 

Code For Converting Date to Quarter

If(
    Month(Now())<=3,
        Set(getQuarterFromDate,"1"),
    Month(Now())>=04 && Month(Now())<=06,
        Set(getQuarterFromDate,"2"),
    Month(Now())>=07 && Month(Now())<=09,
        Set(getQuarterFromDate,"3"),
    Month(Now())>=10,
        Set(getQuarterFromDate,"4")
)

6. Now Set the Default Value to getQuarterFromDate

 

7. Now Click on the Button

 

 

You will see the Current Quarter Value there.

 

That's it