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 

How to Patch Person Lookup with PowerApps

Introduction: 

In this Blog we will see how to Patch Person Lookup with PowerApps with SharePoint.

Implementation Steps:

Consider a Scenario, we need to Update or Set Person Lookup Field from PowerApps

Patch Logged in User to a Lookup Field:

Patch(

    'TABLE NAME',

        PERSONLOOKUPNAME: {

           '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

           Claims: "i:0#.f|membership|"&User().Email,

           Department: "",

           DisplayName: User().DisplayName,

           Email: User().Email,

           JobTitle: "",

           Picture: ""

        }

    }

);

Patch different User to a Lookup Field:

 Patch(

    'TABLE NAME',

        PERSONLOOKUPNAME: {

           '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

           Claims: "i:0#.f|membership|email@emaildomain.com",

           Department: "",

           DisplayName: "USER FULLNAME",

           Email: "email@emaildomain.com",

           JobTitle: "",

           Picture: ""

        }

    }

);

Hope this helps.

Sort and SortBy Columns in PowerApps

Introduction: 

In this Blog we will see what is the main difference between Sort and SortBycolumns in PowerApps

Description:

Table Name "ACCOUNT"

Field Name "AccountName"

Sort: 

Consider i have a COMBOBOX Available i need to show the AccountName in the ComboBox.

So i Set ITEMS of ComboBox = "Account"

Now i want to Sort the Table Account in the Combobox using Account Name, What i can do. I can user SORT query there 

Sort(Account,"AccountName",Ascending)

Account - DataSource (table)

AccountName - Column (Column in Table)

Ascending - Sorting Type (Ascending/Descending)

SortByColumns: 

Now i want to Sort the Table Account in the Combobox using ONLY Account Name, What i can do. I can user SORT query there 

SortByColumns(Account,"AccountName",Ascending)

Account - DataSource (table)

AccountName - Column (Column in Table)

Ascending - Sorting Type (Ascending/Descending)

Is Application User View Not Displaying in User Table for Creating Application User ?

Introduction: 

In this Blog we will see how to create application user without legacy mode.

Implementation Steps:

 

Usually when create an Application User in Azure, we will directly navigate to https://orgname.crm.dyanmics.com then Go to Settings --> then Click Security --> Then User --> Then Change the View to Application User --> Click NEW --> Change View to Application User and Input Client ID and Save.

 

This is how we will follow to create application user, but unfortunately sometimes you cannot see APPLICATION USER View in the User Table in legacy mode.

 

Lets see how to create Application User without Legacy Mode.

 

1. Navigate to https://admin.microsoft.powerplatform.com and click Environments

 

 

 

2. Open the Respective Environment where you want to create Application user --> Once Opened --> Click Settings

 

 

3. Once Settings page Opened --> Click Users + permissions --> then Click Application Users

 

 

4. Click Application User 

 

 

if you want Add, New app User then Click + New app user

 

5. Once Clicked On App user -> Select Add an App

 

 

it will Load all the Application User from https://portal.azure.com

 

 

Now Search for the User and Click Add Once Done --> Add Business Unit and Select Security Role to the User

 

 

For Adding Security Role--> Click Pencil Symbol --> Add the Security Role and Click Save

 

 

 

That's it 

Get office 365 User Email Address powerapps

 Introduction:

In this blog, we will see how to get office 365 user details by filtering logged in user

Implementation Steps:

 

1. Login in to https://make.powerapps.com

2. Create or Open Existing Application

3. Add Office365User Datasource

 

4. Now Add a text field to Populate some details from Office 365.

5. How to Get user Email ?

 

                 User().Email  //Using this syntax we can get email address of user

6. How we can get the Office 365 user Details from PowerApps?

First(Office365Users.SearchUser({searchTerm:User().Email})).UserPrincipalName) // Get User PrincipalName

First(Office365Users.SearchUser({searchTerm:User().Email})).DisplayName) // Get User Display Name

First(Office365Users.SearchUser({searchTerm:User().Email})).Mail) // Get User Mail

First(Office365Users.SearchUser({searchTerm:User().Email})).City) // Get User City

Above i have provided some sample details, you can get more details too :)

Create HTML Table with Border while sending Email using Microsoft Flow

Introduction:

In this Blog, we will see how to send email with Border while Sending email using Microsoft Flow

Implementation Steps:

 

Usually when we send an email with HTML Table Body Microsoft Flow cannot generate Table Border. Below is the Sample Screenshot how the Table will be

 

Microsoft Flow HTML Table With out Border :

 

 

 

Microsoft Flow HTML Table with Border:

 

 

How Can we Achieve this?

 

Open/Create Microsoft Flow --> Open Your Email Notification weather it is Outlook or Send Email Notification

 

First Create Data Operation and Create a HTML Table

 

 

 

Click Code View

 

 

In the Email Body

 

 

Create a <table>Pass your Output Value here</table>

 

HTML Code:

 

<head>
<style>
table {
  font-family: arial, sans-serif;
  border-collapse: collapse;
  width: 100%;
}

td, th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 8px;
}

tr:nth-child(even) {
  background-color: #dddddd;
}
</style>
</head>

 

That's it 

Error Handling in Canvas PowerApps with DataVerse Environment using IfError

Introduction:

In this Blog we will see how to Handle error in Canvas PowerApps with DataVerse Environment using IfError

Implementation Steps:

 

Consider a Scenario, we are having 2 tables one is with Account and another with Opportunity

 

How to Implement Restrict in Dataverse Environment. : https://microsoftcrmtechie.blogspot.com/2022/01/restrict-record-deletion-if-child.html

 

While Deleting Account if any Opportunity Contains Data then we need to Restrict in PowerApps.

 

This Restriction will work Perfectly in Dataverse 

 

In PowerApps Canvas if you tried to delete the system won't throw Error, lets see how to handle that

 

Open Canvas App then Click File then settings 

 

Click Upcoming Features and Toggle On --> Formula-level Error Management

 

 

Now Write below code in Delete Button

 

IfError(Remove([@Accounts], BrowseGallery1.Selected),Notify("Record Contains Child Record"),Notify("Deletion Success"))

 

Thats it  This will throw error if any error occurs 

 

 

Timer Control in PowerApps

 Introduction: 

In this Blog we will see how to Create and Use PowerApps Timer Control in Dataverse Environment.

 Implementation Steps:

 

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

 

2. Create a new Solution

 

3. Add an Existing Entity or Add New Entity 

 

4. Create New Field

         --> Timer End date (Date and Time)

         --> Timer Start date ( Date and Time)

         --> Status Field with (In-Progress, Pending, Completed) (Choice)

 

 

5. Add the Created Fields in the Form

 

 

6. Now Navigate below Steps

• Navigate to https://make.powerapps.com
• Click Gear Icon at the Top  --> Select Advance Settings
• Select Cuztomization --> Click Customize the system
• Expand Entities --> Expand the Table where you have created the fields
• Click Forms --> Open Main Form
• Click Insert at the Top then Select TIMER

 

 

7. Enter the Name and Label

 

• Failure Time Field --> When Timer Should be Failed
• Success Condition --> When Timer Need to be Success
• Failure Condition --> When Timer Need to be Failed
• Warning Condition --> When Timer Need to be Warning
• Cancel Condition --> When Timer Need to be Cancelled
• Pause Condition --> When Timer Need to be Paused

Based on the Attached Imaged I have used my END Date and TIMER STATUS

 

if Status = Pending  (TIMER SHOULD BE : Paused)

 

 

if Status = In-Progress (TIMER SHOULD BE : Warning)

 

 

 

 if Status = Completed (TIMER SHOULD BE : Success)

 

 

 

That's it 

 

Please find my video for Step by Step Process