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