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 :)

Translate Text in Dataverse using AI Builder

Introduction:

In this blog, we will see how to translate text in dataverse using AI Builder

Implementation Steps:

 

1. Create a New Table (Table Name : Translate Text)

 

2. Create Fields

 

         1. Basic Text Name (Datatype : text)

         2. Translated Text (Datatype : text)

         3. Basic language (Datatype : text)

 

3. Once Filed Creation done, add the fields into the Form

 

4. Now Navigate to https://flow.microsoft.com

 

5. Create a New Automated Flow and Select Triggering Point as Dataverse

 

6. Once Page Gets Loaded do the Following mapping

 

 

7. Now Search for AI Builder by clicking + Symbol

 

 

Pass the Text as Basic Text from Dataverse and Converted language to English and Translated From (Auto Detect)

 

8. Now Update the Translated value and base language to Dataverse

 

 

That's it 

 

Output Record below 

 

 

 

For Step by step Guidance, please find my video below

 

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 

Increase / Maximum file size limit for Attachments in Dynamics 365

Introduction: 

In this Blog we will see how to set the Maximum size for the attachments and how to increase size for the attachments.

Implementation Steps:

 

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

 

2. Click Gear Icon at the Top --> Select Advance Settings 

 

3. It will open Settings Page --> Select Administration

 

 

4. Click System Settings

 

 

 

5. Once Page Loaded Select EMAIL Tab

 

 

Select Maximum file size (in kilobytes) and Increase the Size the Of the Attachment.

 

Now Lets see what is the Maximum Size the System will Allow

 

 

Based on Dataverse Environment it will only allow Values between  0 through 131,072.

 

Now Let's See how to Block Unwanted Field Extension Attachments.

 

Click General tab --> Look for Set blocked file extensions for attachments

 

 

That's it 

Get Year Difference between 2 Days using Microsoft Flow

 Introduction: 

In this blog we will see how to count between 2 dates using Microsoft flow

 Implementation Steps:

 

Consider I want to count how many years of experience an Employee have (for Eg) 3 Year experience

So here in my scenario I want to Calculate Today's Year - Employee Joining Year

 

As Starting get the Current Year in a Variable

 

 

 

utcNow()

 

 

 

 

 

The Next step get the Current Year from the Current Date- for that use Substring

 

 

substring(variables('Get Current Date'),0,4)

 

 

 

The same way based on your Dataverse or SharePoint List get the Joining Date of Employee

 

 

As per Above Image, get the State Date and store it in Variable then As said before use subString to get the Year of Joining Date

 

 

substring(variables('Get Anniversery Date'),0,4)

 

 

Now Convert the Variable to int and use sub to get the Count between 2 dates

 

 

sub(int(variables('Get Current Year')),int(variables('Get Anniversery Year')))

 

That's it