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 a 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 well-formed standard business entities, which can be deployed for 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 the Windows Store, we need a Microsoft-related organization’s Office 365 ID (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. On the left side, we can see the individual screens to add our data. On the right side, we see the List of Layouts. At 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 the 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. The 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 saving it.

Output 5. Search the contact. It's 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 understand how to add the Common Data Model in Microsoft PowerApps and how to run it.