Quick Create not opening from Sub grid?

Introduction:

In this blog we will see how to show Quick Create form from Sub grid.

Implementation Steps:

 

Consider I have two entities 

 

1. Table 1 

2. Table 2.

 

I need to Open Table 1 as a Quick create from Table 2 SUBGRID.

 

Lets see how we can do that.

 

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

 

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

 

3. Click Settings--> Customization --> Customize the System

 

4. It will Open a Page --> Expand Entities --> Click Table1 --> Make Sure you will Check ALLOW QUICK CREATE

 

 

 

5. Once the Above Step Done --> Click Save and Publish

 

6. Once Publish done --> Navigate to https://make.powerapps.com 

 

7. Click Apps --> Select your Model Driven Apps --> Click Edit --> Expand Entity View --> Select the Table --> Select Quick Create Form 

 

 

8. Once Check Box done --> Click Save --> Click Publish

 

9. Once done --> Close all the window and Publish All Customization.

 

That's it 

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

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