Custom Page CRUD operation with Dataverse

Custom pages are very useful in use cases where you need custom designs and controls. In this post you will come to know how to RETRIEVE, CREATE, UPDATE and DELETE records of Dataverse from Custom Page.

Use below PowerFX to Create Record.

Patch(
    Investments,
    Defaults(Investments),
    {
        Type: If(
            GALroi.Selected.Label3.Text = "Fixed Deposit",
            'Type (Investments)'.'Fixed Deposit',
            GALroi.Selected.Label3.Text = "Recurring Deposit",
             'Type (Investments)'.'Recurring Deposit'),
             Amount:800,
             Name:"Investment for " & galCustomer.Selected.'Full Name',
             Customer:galCustomer.Selected,
             'Rate of Interest':ROI.'8.3',
             'Tenure in months':30
    }
);
Notify("Invetstment created for the selected customer.")

You can update using below PowerFX using For loop.

ForAll(
    Filter(
        galinv.AllItems,
        chkinvest.Checked = true
    ),
    Patch(
        Investments,
        ThisRecord,
        {Amount: 1000}
    )
);

Hope this helps.

Follow my blog for more trending topics on Dynamics 365, Azure, C#, Power Portals and Power Platform. For training, Courses and consulting, call to us at +91 832 886 5778 I am working more for community to share skills in Dynamics 365 and Power Platform. Please support me by subscribing my YouTube Channel. My YouTube Channel link is this : https://www.youtube.com/user/sppmaestro