How to Use the Dataverse Patch Function?

Create a canvas application

To show how the Dataverse Patch function works, let's start by making a digital tool using Microsoft PowerApps. Here's how we do it:

• Open PowerApps.
• Click on 'Create.'
• Pick 'Blank app.'
• Choose 'Blank canvas app.'
  
• Give the app name and choose a format for how it should look.
  

By doing these steps, we make a tool where we can try out the Dataverse Patch function's abilities.

Establishing Connections and Designing the Interface

To work with Dataverse info, we need to connect. The app's look is made for using Dataverse lists and their parts. 'AAD user' helps make user records and a list is made for them.

Next, a page is made in the app. On this page, we put controls that match the 'Employees' table. We link the table's columns to the right input controls. This makes things easy to use and understand for people.

I have created a screen design something like this,

Implementing the Dataverse Patch Function

Our main goal is to use the Dataverse Patch function to handle the data in the 'Employees' table really well. We use the Patch function for this.

Patch(
    Employees,
    Defaults(Employees),
    {
        Name: txtName.Text,
        BirthDate: dpBirthDate.SelectedDate,
        Email: txtEmail.Text,
        Notes: txtNotes.Text,
        Department: ddDepartment.Selected.Value,
        Resume: {
            FileName: First(resume.Attachments).Name,
            Value: First(resume.Attachments).Value
        },
        Skills: multiSelectSkills.SelectedItems,
        Manager: LookUp(
            'AAD Users',
            'Display Name' = ddManager.Selected.'Display Name'
        ),
        Salary: Value(txtSalary.Text),
        ProfileImage: imgProfile.Image
    }
);

This code segment showcases the integration of the Patch function, as it maps input values from controls to their respective columns. The function accommodates various data types, such as text, dates, attachments, lookups, and images.

Output

Conclusion

This article offers a straightforward, step-by-step guide on saving records in a Dataverse table, even with complex columns.

I hope this helps.

Sharing is caring!