Add Common Data Model(CDM) In Microsoft PowerApps

Before reading this article, please go through the article's link, mentioned below.

• Quick Start on Microsoft PowerApps - To know about the PowerApps
• Build Asset Checkout App Using Microsoft PowerApps - To use the Template
• How To Build Blank Apps Using Microsoft PowerApps - To use Blank app
• How To Add Excel Data Source In Microsoft PowerApps - Add Excel file

In PowerApps, we can add the Common Data Model(CDM).

Microsoft Common Data Model

Microsoft Common Data Model (CDM) is a secure business database that comprises of well-formed standard business entities, which can be deployed for the use in your organization. Common Data Model is a standardized definition of how the system solutions and technologies represent the resources and their relationships.

Follow the steps, mentioned below to work with sort in PowerApps.

Step 1

Log into PowerApps

After downloading PowerApps from Windows Store, we need Microsoft related organization’s Office 365 ID or (MSDN, Microsoft, Skype, Office 365 etc.) to login with it.



Step 2 Create a New App in PowerApp

After login, we can see the dashboard. Subsequently, we click on the New button.



Step 3 Choose the Common Data Model



Additionally, go to New and choose the Common Data Mode. Click on the Contact.



Step 4 Designing the App

Now, let's start designing the app. In left side, we can see the individual screens to add our data. In right side, we see the List of Layouts. In the top, we see the formula bar. You have seen the Properties of the screen, which you selected. In the right side, we see the Add DataSource to add the external DataSource.



Step 5

Choose the Layout.



Step 6

Configure CDM.



Select Text box in the gallery and click on the Contact button.

Step 7

Select the Display Field.

Choose Field to display on the text box.



Step 8 Add the coding

Click on the gallery and add the coding, mentioned below to the Item Event.

Coding

SortByColumns(Search(Contact, TextSearchBox1.Text, "FirstName"), "FirstName", If(SortDescending1, Descending, Ascending))



Step 9

Run the app.



Output 1

Main screen is mentioned below.



Output 2

Searching the contact is mentioned below.



Output 3

Adding the contact is mentioned below.



Output 4

Entering the data and subsequently save it.



Output 5

Search the contact. Its updated. Subsequently, click on it.



Output 6

Edit the details of the contact.



Output 7

Edit the data.



Output 8

The edited field is updated.



Conclusion

I hope, you understood how to add Common Data Model in Microsoft PowerApps and how to run it.