Add Common Data Model(CDM) In Microsoft PowerApps

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

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.

PowerApp

Step 2 Create a New App in PowerApp

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

PowerApp

Step 3 Choose the Common Data Model

PowerApp

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

PowerApp

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.

PowerApp

Step 5

Choose the Layout.

PowerApp

Step 6

Configure CDM.

PowerApp

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.

PowerApp

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

PowerApp

Step 9

Run the app.

PowerApp

Output 1

Main screen is mentioned below.

PowerApp

Output 2

Searching the contact is mentioned below.

PowerApp

Output 3

Adding the contact is mentioned below.

PowerApp

Output 4

Entering the data and subsequently save it.

PowerApp

Output 5

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

PowerApp

Output 6

Edit the details of the contact.

PowerApp

Output 7

Edit the data.

PowerApp

Output 8

The edited field is updated.

PowerApp

Conclusion

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