Patch Function in Custom Pages Power Apps

In Power Apps, you can create a Custom Page to leverage the Canvas App capabilities inside Model Driven App. In this post you will learn how to CREATE or UPDATE Dataverse records from custom page.

Create a custom page inside your solution with a gallery connected to Contact table, another gallery to display Rate Of Interest table.

Take a button and write the PowerFX given below. The scenario is, the custom page should display 3 gallery, one customer data, another rate of interest data and third investments data.

When a user select an item from Rate of Interest gallery and select a customer from customer gallery, a new investment record should be created in Dataverse.

The below is the UI designed for the custom page and galleries are connected to respective tables.

On the button use below PowerFX.

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("Investment created for the selected customer.")

Publish the Custom Page and Add the page inside model driven app and publish both to test. Now test the app.

You can enroll now !We are giving 30% discount on our Internship Program

Don’t miss the chance to participate in the upcoming Internship Program which will be done using Microsoft Dot Net Web Development Full Stack Technology. The new batch will be starting from May 20, 2024.  We will have most experienced trainers for you to successfully complete the internship with live project experience.

Why to choose Our Internship Program?

Industry-Relevant Projects
Tailored Assignments: We offer projects that align with your academic background and career aspirations.
Real-World Challenges: Tackle industry-specific problems and contribute to meaningful projects that make a difference.

Professional Mentorship
Guidance from Experts: Benefit from one-on-one mentorship from seasoned professionals in your field.
Career Development Workshops: Participate in workshops that focus on resume building, interview skills, and career planning.

Networking Opportunities
Connect with Industry Leaders: Build relationships with professionals and expand your professional network.
Peer Interaction: Collaborate with fellow interns and exchange ideas, fostering a supportive and collaborative environment.

Skill Enhancement
Hands-On Experience: Gain practical skills and learn new technologies through project-based learning.
Soft Skills Development: Enhance communication, teamwork, and problem-solving skills essential for career success.

Book Your Seat Now

Free Demo Class Available