web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages - Design & Build / CRUD operation on Data...
Power Pages - Design & Build
Answered

CRUD operation on Datavese through Forms

(1) ShareShare
ReportReport
Posted on by CapG 36
Hi,
 
I am trying to build a Forms in my Power pages website where the suer can perform CRUD on the tables.

product to productsize as 1:n
I have a producsize view on one webpge where it displays columns from both the tables and to each record in the list I need to give CRUD rights to the user to edit the columns of both the tables.

How to add a logic to the webpage or list so the user can edit all the records of product and productsize tables through one form?
 
 
Thanks!
Categories:
General
I have the same question (0)
  • Verified answer
    Jerry-IN Profile Picture
    Jerry-IN 267 on at
    CRUD operation on Datavese through Forms
    Hello CapG ,
     
    To enable CRUD operations on related tables (product and productsize in a 1:n relationship) through a single form on a Power Pages site, the recommended approach is to use the Form Component Control or Subgrid on a Dataverse model-driven form that embeds the child records within the parent form. Here's how:
     
    Approach 1: Use Form Component Control (Inline Editing on Single Form)- In Power Apps maker portal, open the solution and select the **Product** table.- Open the main form for Product.
    • Insert a **Form Component Control** and configure it to show the **ProductSize** related form inline.
    • This allows users to edit Product and associated ProductSize records within one form, either on separate tabs or sections.
    • Customize the fields shown on both parent and child forms as needed.
    • Save and publish the form.
    • On Power Pages, the portal page tied to the Product entity will allow editing of both Product and linked ProductSize in one place.
    Approach 2: Use an Editable Subgrid (Separate Editable List inside the Form)
    • On the Product form, add a **Subgrid** showing related ProductSize records.
    • Enable **Editable Grid** for the ProductSize entity and views.
    • Users can edit ProductSize records in the subgrid, while the main form handles Product.
    • This approach keeps the tables distinct but enables inline edits, deletes, adds on ProductSize records.
    Permissions and Configuration
    • Ensure Dataverse table permissions allow portal users to create, read, update, delete (CRUD) both entities.
    • Configure portal Web Roles to include these permissions.
    • Use lookup column filters to connect the tables properly.
    • Test in portal preview to verify seamless editing.
    Reference
    • Microsoft Learn on [Add the form component to a table main form](https://learn.microsoft.com/en-us/powerapps/maker/model-driven-apps/add-form-component-control)
    • Microsoft Learn on [Add and configure a subgrid component on a form](https://learn.microsoft.com/en-us/powerapps/maker/model-driven-apps/add-subgrid-component)
    • If you want code examples or walkthroughs for form customization or permissions setup, just ask.
     
    Best Regards,  
    Jerald Felix
     
  • CapG Profile Picture
    CapG 36 on at
    CRUD operation on Datavese through Forms
    Hi @Jerry-IN,

    My requirement is on power pages. Power pages does not allow editable subgrids.

    Mutistep forms might be helpful in this scenario

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Jerry-IN Profile Picture

Jerry-IN 64

#2
Fubar Profile Picture

Fubar 46 Super User 2025 Season 2

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 27 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans